Skip to content

Instantly share code, notes, and snippets.

@ryanking

ryanking/find id fields without indexes

Created February 22, 2009 20:56
Show Gist options
  • Save ryanking/68614 to your computer and use it in GitHub Desktop.
Save ryanking/68614 to your computer and use it in GitHub Desktop.
Download ZIP
These fields almost always need an index in rails.
Raw
find id fields without indexes
select table_name, column_name, column_key from columns where table_schema='YOURDB' and column_name like '%id' and column_key='';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment