Problem Statement
Improving Micro-Partition Pruning on a Large Snowflake Table A Snowflake query scans a very large table but usually filters on TRANSACTION_DATE and REGION . The table is loaded daily and query cost is increasing. Which action is most appropriate to improve pruning and reduce unnecessary scanning?