Which statistics on a Query Profile reflect the efficiency of the query pruning? (Choose two.)
Which statistics on a Query Profile reflect the efficiency of the query pruning? (Choose two.)
The efficiency of the query pruning can be reflected by examining the statistics on the number of partitions scanned versus the total number of partitions. By assessing these two statistics, one can determine how effectively the query engine avoids scanning unnecessary partitions, thus optimizing performance.
Statistics A major source of information provided in the detail pane is the various statistics, grouped in the following sections: Pruning — information on the effects of table pruning: Partitions scanned — number of partitions scanned so far. Partitions total — total number of partitions in a given table. https://docs.snowflake.com/en/user-guide/ui-query-profile