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.

https://www.percona.com/blog/2015/05/08/mysql-indexing-101-a-challenging-single-table-query/