Q

Analyzing indexes

Is there a way to analyze indexes on MySQL?

The indexes themselves cannot be analyzed, but we can use the EXPLAIN functionality to analyze a the INDEX usage of a query. The EXPLAIN syntax is detailed at http://dev.mysql.com/doc/mysql/en/EXPLAIN.html.


This was first published in August 2004

Dig deeper on Open source databases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close