Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / Optimization  / Optimization and Indexes  /  Verifying Index Usage

8.3.6 Verifying Index Usage

Always check whether all your queries really use the indexes that you have created in the tables. Use theEXPLAIN statement, as described inSection 8.8.1, “Optimizing Queries with EXPLAIN”.