Skip to content

Instantly share code, notes, and snippets.

@stilliard

stilliard/select_different_indexes_on_the_same_table_across_all_databases.sql

Created August 25, 2015 09:09
Show Gist options
  • Save stilliard/4874172ac0ce7a4ea435 to your computer and use it in GitHub Desktop.
Save stilliard/4874172ac0ce7a4ea435 to your computer and use it in GitHub Desktop.
Download ZIP
Select different indexes on the same table across all databases on a server (e.g. a `categories` table)
Raw
select_different_indexes_on_the_same_table_across_all_databases.sql
SELECT table_name, index_name, GROUP_CONCAT(DISTINCT column_name), index_type
FROM information_schema.statistics
WHERE table_name = 'categories'
AND non_unique = 1
GROUP BY table_name, index_name, index_type
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment