It is important to know and understand that while indexing columns in MySQL will generally improve performance, using the appropriate type of index can make a greater impact on performance.
There are four general index types to consider when creating an appropriate index to optimize SQL queries.
- Column Index
- Concatenated Index
- Covering Index
- Partial Index
For the purpose of this discussion I am excluding other specialized index types such as fulltext, spatial and hash in memory engine.
For the following examples, I will …[Read more...]