Documentation Home
MySQL 9.1 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
Man Pages (TGZ) - 259.5Kb
Man Pages (Zip) - 366.7Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


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

10.3.7 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 10.8.1, “Optimizing Queries with EXPLAIN”.