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.