How can a user determine whether a micro-partition is being pruned efficiently?
Efficient micro-partition pruning is indicated in the Query Profile’s TableScan statistics when Partitions scanned is a small fraction of Partitions total. This shows that the query avoided scanning unnecessary micro-partitions.
Community Discussion