MySQL Optimization / INDEX fields

Here we show you a simple and easy method to increase your MySQL query speeds. This is usefull when you programming by our own. The most 3rd-Party-Software use a correct database and field selection.

Index

Index is usefull in larger databases or tables with high usage. Index all fields which you use for searching in (WHERE) queries. For example:

SELECT * FROM my_table WHERE url=’ABC‘ LIMIT 1

In this case we need to index our „url“ field in database „my_table“.

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.