Show All Indexes On a DB

Posted . Visible to the public.

Again, not Magento. Very handy though!

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.

Mike Whitby
Last edit
Posted by Mike Whitby to Magento (2014-05-22 15:15)