MySQL :: MySQL 9.6 Reference Manual :: 10.3.7 Verifying Index Usage

PDF (US Ltr) - 41.8Mb
PDF (A4) - 41.9Mb
Man Pages (TGZ) - 272.3Kb
Man Pages (Zip) - 378.1Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb

version 9.6

9.5
9.4
9.3
9.2
9.1
9.0
8.4 current
8.0
5.7

8.0 Japanese

MySQL 9.6 Reference Manual / ... / Verifying Index Usage

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

PREV HOME UP NEXT

PDF (US Ltr) - 41.8Mb
PDF (A4) - 41.9Mb
Man Pages (TGZ) - 272.3Kb
Man Pages (Zip) - 378.1Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb