Query Optimization — EXPLAIN ANALYZE / Hash vs Merge vs Nested Loop
MidProfessionalpriority 1Sandbox & Simulation
This is the Sprint-1 stub for ai.careerplane.finance.actuary.sql.query-optimization.
The fully-generated topic page (sandbox + quiz + AI hints + interactive
tooling) lands in Sprint-2 at
static/content/finance/Actuary/SQL/Query Optimization — EXPLAIN ANALYZE / Hash vs Merge vs Nested Loop/index.html
(per arch/memo.md → D-2026-04-22-13). The
//go:embed all:static directive auto-serves it on the next
container rebuild — no server-code change needed.
What this topic teaches
SQL skills for the
Actuary career path.
sqlexplainquery-planoptimizerhash-joinnested-loop
You should already know
PIVOT / UNPIVOT & Conditional Aggregates for Reporting