The Query Profile in the image is for a query executed in Snowsight. Four of the key nodes are highlighted in yellow.
Which highlighted node will be the MOST expensive?
The Query Profile in the image is for a query executed in Snowsight. Four of the key nodes are highlighted in yellow.
Which highlighted node will be the MOST expensive?
The most expensive node in a query execution plan typically corresponds to the one consuming the highest percentage of total execution time. In the provided query profile, the
D: https://www.examtopics.com/exams/snowflake/snowpro-core/view/11/
correct
can you explain?
https://docs.snowflake.com/en/user-guide/ui-query-profile Operator Nodes by Execution Time A collapsible panel in the operator tree pane lists nodes by execution time in descending order, enabling users to quickly locate the costliest operator nodes in terms of execution time. The panel lists all nodes that lasted for 1% or longer of the total execution time of the query (or the execution time for the displayed query step, if the query was executed in multiple processing steps). Execution Time Provides information about which processing tasks consumed query time (described in Query/Operator Details below). Additionally, for step-level information, it shows the state of the given step, and its execution time.
Execution time provides information about “where the time was spent” during the processing of a query