Posted almost 10 years ago. Visible to the public. Repeats. Linked content.
Add indexes on foreign keys when you create a migration (with foreign key)
Whenever you make a migration to add a foreign key, you should also add an index for it
Copydef self.up add_column :comments, :user_id, :integer add_index :comments, :user_id end