QuestionQ29Verified/SQLCopy linkReport a problemAsk AstroTutorSave questionHow can Query Profile be used to identify a query’s most costly operator?ASelect any node in the operator tree and look at the number of micro-partitions scanned.BFind the operator node with the highest fraction of time or percentage of total time.CSelect the TableScan operator node and look at the percentage scanned from cache.DLook at the number of rows between operator nodes across the operator tree.Show AnswerAnswerExplanationThe costliest operator is the operator node with the greatest fraction of execution time, expressed as the highest percentage of total query time. Metrics such as micro-partitions scanned, cache use, and rows exchanged are diagnostic details rather than the direct measure of an operator’s relative execution cost.Show comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion