Pruning in Snowflake: Working Smarter, Not Harder

Summary: Extends pruning from predicates to LIMIT, top-k, and JOIN, broadening pruning across workloads. Using min/max metadata and Iceberg-style formats, it prunes up to 99.4% of micro-partitions in Snowflake workloads and reveals higher real-world selectivity. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 7111
Venue: SIGMOD
Year: 2025
Pagerank: 4.5154358e-05
Overall Rank: 8,410 | 41.56%
DOI: 10.1145/3722212.3724447

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,196	PTO: A Workload-driven Predictive Table Optimizer for Lakehouse Systems	2026	SIGMOD	4.1905499e-05
10,241	Robust Predicate Transfer with Dynamic Execution	2026	VLDB	4.1905499e-05
10,755	Scaling GPU-Accelerated Databases beyond GPU Memory Size	2025	VLDB	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 25 of 25 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
8	Optimal Aggregation Algorithms for Middleware [Extended Abstract]	2001	PODS	0.0015436578
44	The Design Of Postgres	1986	SIGMOD	0.00071946446
80	Weaving Relations for Cache Performance	2001	VLDB	0.00055735291
167	The Snowflake Elastic Data Warehouse	2016	SIGMOD	0.00039408116
185	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00036529607
269	R* Optimizer Validation and Performance Evaluation for Local Queries	1986	SIGMOD	0.00029665158
283	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00029024583
367	Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing	1998	VLDB	0.00025518228
1,401	Analytic Database Technologies for a New Kind of User - The Data Enthusiast	2012	SIGMOD	0.00012190914
1,470	Processing a Trillion Cells per Mouse Click	2012	VLDB	0.00011827274
1,473	Fine-grained Partitioning for Aggressive Data Skipping	2014	SIGMOD	0.00011786148
1,608	Qd-tree: Learning Data Layouts for Big Data Analytics	2020	SIGMOD	0.00011169837
2,914	Quantifying TPC-H Choke Points and Their Optimizations	2020	VLDB	7.9197583e-05
2,937	DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems	2021	VLDB	7.8552033e-05
3,160	Horizontal Data Partitioning In Database Design	1982	SIGMOD	7.4649653e-05
3,482	Optimal Column Layout for Hybrid Workloads	2019	VLDB	7.0514808e-05
3,731	Skipping-oriented Partitioning for Columnar Layouts	2017	VLDB	6.8074069e-05
3,777	Instance-Optimized Data Layouts for Cloud Analytics Workloads	2021	SIGMOD	6.7713324e-05
3,923	Pushing Data-Induced Predicates Through Joins in Big-Data Clusters	2020	VLDB	6.6232068e-05
4,157	Performance-Optimal Filtering: Bloom Overtakes Cuckoo at High Throughput	2019	VLDB	6.3935343e-05
4,681	Cloud Analytics Benchmark	2023	VLDB	5.9953512e-05
5,316	Cuckoo Index: A Lightweight Secondary Index Structure	2020	VLDB	5.5688295e-05
6,971	Predicate Caching: Query-Driven Secondary Indexing for Cloud Data Warehouses	2024	SIGMOD	4.8738633e-05
8,434	SageDB: An Instance-Optimized Data Analytics System	2022	VLDB	4.5077955e-05
8,886	Provenance-based Data Skipping	2022	VLDB	4.4237386e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
9,700	Towards Functional Decomposition of Storage Formats	2025	CIDR	4.2967256e-05
7,907	Petabyte-Scale Row-Level Operations in Data Lakehouses	2024	VLDB	4.6161532e-05
8,777	Accelerate Distributed Joins with Predicate Transfer	2025	SIGMOD	4.4492064e-05
7,096	Optimizing Queries over Partitioned Tables in MPP Systems	2014	SIGMOD	4.8283743e-05
1,967	Efficient Computation of Iceberg Cubes with Complex Measures	2001	SIGMOD	9.9108189e-05
1,473	Fine-grained Partitioning for Aggressive Data Skipping	2014	SIGMOD	0.00011786148
12,001	A Partitioning Framework for Aggressive Data Skipping	2014	VLDB	4.1905499e-05
8,070	Optimizing Iceberg Queries with Complex Joins	2017	SIGMOD	4.5893281e-05
3,777	Instance-Optimized Data Layouts for Cloud Analytics Workloads	2021	SIGMOD	6.7713324e-05
8,880	Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like?	2025	VLDB	4.4254065e-05