Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
How can the Query Profile be utilized to identify the most expensive operator in a query?
A
Select any node in the operator tree and look at the number of micro-partitions scanned.
B
Find the operator node with the highest fraction of time or percentage of total time.
C
Select the TableScan operator node and look at the percentage scanned from cache.
D
Look at the number of rows between operator nodes across the operator tree.