Posted about 5 years ago. Visible to the public.

Show All Indexes On a DB

Again, not Magento. Very handy though!

Copy
SELECT DISTINCT TABLE_NAME, INDEX_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'your_schema';

Then you can use show indexes from table_name to see more info about the index.

Owner of this card:

Avatar
Mike Whitby
Last edit:
about 5 years ago
Posted by Mike Whitby to Magento
This website uses cookies to improve usability and analyze traffic.
Accept or learn more