MySQL query tuning trilogy: indexing and EXPLAIN deep dive

This is part 2 of our webinar trilogy on MySQL Query Tuning, in which we look at query tuning process and tools to help with that. We’ve covered topics such as SQL tuning, indexing, the optimizer and how to leverage EXPLAIN to gain insight into execution plans. Part 2: Indexing and EXPLAIN – deep dive.

Content of the webinar

• How B-Tree indexes are built?
• Indexes – MyISAM vs. InnoDB
• Different index types
  • B-Tree
  • Fulltext
  • Hash
• Indexing gotchas
• EXPLAIN walkthrough – query execution plan