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 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 1In this case we need to index our “url” field in database “my_table”.