Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.
