What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
Snowflake uses the technique of pruning to limit the number of micro-partitions scanned by each query. Pruning involves selecting only the relevant micro-partitions based on the filtering criteria of the query, thereby optimizing query performance and reducing resource consumption.
D correct - https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions