Covering Index

MySQL Percona Live 2015

Percona Live Presentation: Improving Performance With Better Indexes

Ronald Bradford
April 15, 2015

The slides for my Improving Performance With Better Indexes presentation at Percona Live 2015 MySQL Conference and Expo are now available. In this presentation I discuss how to identify, review and analyze SQL statements in order to create better indexes for your queries.

Databases General MySQL Uncategorized

Explain this

Ronald Bradford
September 15, 2009

The EXPLAIN command is an important tool to review how a SQL query is executed and in this example includes what indexes are used. By adding a covering index I ended up with the following EXPLAIN plan I was unable to explain.

Databases General Linux MySQL Open Source

Understanding Different MySQL Index Implementations

Ronald Bradford
July 23, 2009

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.