You are here

MySQL indexing 101: a challenging single-table query

MySQL Performance Blog - Fri, 08/05/2015 - 7:00am

We discussed in an earlier post how to design indexes for many types of queries using a single table. Here is a real-world example of the challenges you will face when trying to optimize queries: two similar queries, but one is performing a full table scan while the other one is using the index we […]

The post MySQL indexing 101: a challenging single-table query appeared first on MySQL Performance Blog.