×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Identifying all the Index(s) Available on a Table in MySQL
 

Submitted by: M S Sridhar(sridhar.ms@gmail.com)

Tuesday Feb 20th 2018 by M S Sridhar

Language: SQL, Expertise: Intermediate - Learn a way to increase performance in MySQL.

There are many ways for a DBA to increase performance and you may want to use some of them in your code.

For example, you may want to list all the indexes that have been created on a table in MySQL. Using the following command, you will be able to list down all the indexes that are available for the table.

SHOW INDEX FROM `database_name`.`TABLE_NAME`;

This command will list all the indexes that are available and the column(s) that have been used for index, along with the index type. Try it for yourself!

Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved