Skip to main content

optimizing_sql_indexes

🏷️ Optimize SQL Indexes​

Adding or tweaking indexes can drastically speed up queries on large tables. Analyze slow queries and add indexes on frequently filtered or joined columns.

# migration to add index
generate migration AddIndexToUsersEmail
# in the generated migration
def change
  add_index :users, :email
end