Patterns · Vol. 02

Pattern

sql-optimization-patterns

Optimize SQL by reading the query plan first — parse EXPLAIN output, identify the actual bottleneck, then make targeted changes, rather than reaching for indexes or rewrites on instinct.

Classification — Domain skill — query optimization

Full entry

The complete treatment — problem, how it works, when to use it, sources, and examples — lives in the volume below.

Browse the full pattern index or the catalog.