MySQL

Using Indexing

We'll discuss indexing first because it's the most important tool you have for speeding up your queries. There are other techniques available to you, too, but generally the one thing that will make the most difference is the proper use of indexes. On the MySQL mailing list, people often ask for help in making a query run faster. In a surprisingly large number of cases, there are no indexes on the tables in question, and adding indexes often solves the problem immediately. It doesn't always work like that because optimization isn't always simple. Nevertheless, if you don't use indexes, then in many cases you're just wasting your time trying to improve performance by other means. Use indexing first to get the biggest performance ...