SQL

Purpose

Write SQL that the planner can execute efficiently, and read execution plans well enough to know why it did not.

When to Use

• Writing non-trivial queries: aggregations, window functions, recursive CTEs.
• Diagnosing a slow query.
• Designing indexes for a known access pattern.
• Choosing a transaction isolation level.
• Reviewing migrations for lock risk.

Capabilities