How can we get the list of all the indexes on a table?

We can use following command to get the list of all the indexes on a table in MySQL:

SHOW INDEX FROM table_name;

At maximum we can use 16 columns in a multi-column index of table.

Read the full book at www.amazon.com
Posted in MySQL, MySQL Interview Questions

Leave a Reply

Your email address will not be published. Required fields are marked *

*