Answer-first summary for fast verification
Answer: An explain plan can be used to conduct performance analysis without executing a query.
The correct answer is B because an EXPLAIN plan compiles and analyzes the SQL query without executing it, allowing for performance analysis without consuming compute credits or requiring a running warehouse. This is a key advantage over the Query Profile, which requires query execution to generate performance data. Option A is incorrect because both EXPLAIN and Query Profile provide graphical output in Snowflake. Option C is incorrect because both tools can handle queries with temporary tables. Option D is incorrect because EXPLAIN does not display automatic data skew optimization information, which is typically shown in the Query Profile after execution.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is an advantage of using an EXPLAIN plan over the Query Profile to evaluate query performance?
A
The explain plan output is available graphically.
B
An explain plan can be used to conduct performance analysis without executing a query.
C
An explain plan will handle queries with temporary tables and the query profiler will not.
D
An explain plan's output will display automatic data skew optimization information.
No comments yet.