Database Query Optimization

Databasesdb

The Question

What techniques do you use to optimize database queries?

What a Strong Answer Covers

• EXPLAIN vs EXPLAIN ANALYZE
• seq scan vs index scan.

Related Questions

• ACID
• Indexes
• Clustered vs Non-clustered
• Isolation Levels
• Normalization