Core concept
ANALYZE TABLE t COMPUTE STATISTICS. Column stats via COMPUTE STATISTICS FOR COLUMNS.
Advertisement
How it works
Missing/stale stats = bad plans. Recompute after big data changes.
Advertisement
Trade-offs + gotchas
Every prod table.