I have recently seen several cases when performance for MySQL queries on a single table was terrible. The reason was simple: the wrong indexes were added and so the execution plan was poor. Here are guidelines to help you optimize various kinds of single-table queries. Disclaimer: I will be presenting general guidelines and I do [&]

The post Indexing 101: Optimizing MySQL queries on a single table appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/27/indexing-101-optimizing-mysql-queries-on-a-single-table/