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”.

Leave a Reply

Your email address will not be published. Required fields are marked *