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

  def self.up
    add_column :comments, :user_id, :integer
    add_index :comments, :user_id
  end
Dragos Miron over 9 years ago
This website uses short-lived cookies to improve usability.
Accept or learn more