Skip navigation links

The world's most popular open source database

Login | Register

Developer Zone
Downloads
Documentation

MySQL Server
MySQL Enterprise
MySQL Workbench
MySQL Cluster
MySQL Connectors
Topic Guides
Expert Guides
Other Docs
Archives
About

Documentation Library
- Table of Contents
  - MySQL 5.7 Manual
  - MySQL 5.6 Manual
  - MySQL 5.5 Manual
  - MySQL 5.1 Manual
  - MySQL 5.0 Manual
  - MySQL 3.23/4.0/4.1 Manual

Search manual:

MySQL 5.5 Reference Manual :: 8 Optimization :: 8.3 Optimization and Indexes :: 8.3.6 Verifying Index Usage

« 8.3.5 Multiple-Column Indexes

8.3.7 InnoDB and MyISAM Index Statistics Collection »

Section Navigation [Toggle]

8.3 Optimization and Indexes
8.3.1 How MySQL Uses Indexes
8.3.2 Using Primary Keys
8.3.3 Using Foreign Keys
8.3.4 Column Indexes
8.3.5 Multiple-Column Indexes
8.3.6 Verifying Index Usage
8.3.7 InnoDB and MyISAM Index Statistics Collection
8.3.8 Comparison of B-Tree and Hash Indexes

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

Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

Developer Zone
Documentation
Developer Articles
News & Events
Forums
Lists
Bugs
Worklog
Planet MySQL
Labs

Downloads
MySQL Community Server
MySQL Proxy
MySQL Cluster
MySQL Workbench
MySQL Connectors
Archives

Documentation
MySQL Reference Manuals
MySQL Workbench
Expert Guides
Topic Guides
MySQL Cluster
Other Documents
About
Archives

About MySQL
Contact Us
How to Buy
Partners
Job Opportunities
Site Map

Legal
Legal Policies
Your Privacy Rights
Terms of Use
Trademark Policy
Contributor Agreement

© 2013, Oracle Corporation and/or its affiliates