Question
Query Profile vs. EXPLAIN: what does each diagnose, and when should each be used?
Answer
Query Profile shows actual execution operators, elapsed time, data movement, scans, and spills for a completed query. EXPLAIN shows the planned execution before running it. Use EXPLAIN for pre-change assessment; use Query Profile to diagnose observed behavior.