What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
An explain plan can be used to conduct performance analysis without executing a query. This allows for the assessment of query performance without needing to consume resources or time to actually run the query, making it a valuable tool for optimization and planning.
EXPLAIN compiles the SQL statement, but does not execute it, so EXPLAIN does not require a running warehouse. Although EXPLAIN does not consume any compute credits, the compilation of the query does consume Cloud Service credits, just as other metadata operations do. https://docs.snowflake.com/en/sql-reference/sql/explain.html
https://docs.snowflake.com/en/sql-reference/sql/explain.html
B. An explain plan can be used to conduct performance analysis without executing a query.
Correct
Correct