Snowflake DBA

Query Performance Diagnostics

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.

This is 11 of 21 free samples for Snowflake DBA.

More Snowflake DBA topic samples