Working with Indexes — Best Practices for MySQL 5.6
summary
Practical guidance on using indexes in MySQL 5.6: how the MySQL 5.6 optimizer uses indexes to execute queries, how to design an optimal indexing strategy, when to add an index, and how to identify and remove unnecessary indexes. The talk is based on optimizer improvements in MySQL 5.6 and presents best practices for index management.
AI-written summary · about
related talks
47mMySQL Indexing Best Practices
36mFor performance, go to page 5: Indexes
01mHow well do you know your MySQL Indexes?
48mMySQL Indexing - Do It Right or Die
46mSupercharge Your SQL with Indexes: a Practical Introduction
57mPerformance Analysis and Optimization of MySQL
54mPerformance Analysis and Optimization of MySQL
25mThe Secret Life of SQL: How to Optimize Database Performance