SQL Query Optimization Guide

This guide covers SQL query optimization techniques including reading execution plans, choosing appropriate indexes, table partitioning, and identifying 20 common anti-patterns that degrade performance. It provides engine-specific examples for PostgreSQL and MySQL with tools for finding slow queries, detecting missing indexes, and query rewrite patterns with measured improvements.