Show All Indexes On a DB
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.