DBScholar

Back to papers

Exploiting Statistics on Query Expressions for Optimization

Summary: Extends the optimizer to exploit statistics on intermediate query expressions (not just base-table stats), yielding better plan quality. Proposes a workload-driven feature selection to identify a small, impactful subset of expressions' statistics, with validation on SQL Server 2000. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h9eb9f0efaf325dea
Venue
SIGMOD
Year
2002
Pagerank
0.0001520859
Overall Rank
646 | 95.66%
DOI
10.1145/564691.564722

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{bruno_sigmod02,
        title = {{Exploiting Statistics on Query Expressions for Optimization}},
        author = {Bruno, Nicolas and Chaudhuri, Surajit},
        series = {{SIGMOD} '02},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/564691.564722},
        url = {https://dl.acm.org/doi/10.1145/564691.564722},
        year = {2002}
}

Incoming Citations (Sorted by Pagerank)

Showing 38 of 38 citing papers.

Rank Citing Paper Year Venue Pagerank
160 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00027837289
255 The History of Histograms (abridged) 2003 VLDB 0.00022981861
481 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.00017603972
827 Adaptive Ordering of Pipelined Stream Filters 2004 SIGMOD 0.00013632674
1,257 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011310561
1,603 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2019 SIGMOD 0.00010097649
1,662 BHUNT: Automatic Discovery of Fuzzy Algebraic Constraints in Relational Data 2003 VLDB 9.9465656e-05
1,800 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2018 VLDB 9.6093317e-05
1,890 Generating Targeted Queries for Database Testing 2008 SIGMOD 9.4193315e-05
1,929 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 9.3546057e-05
2,172 A Black-Box Approach to Query Cardinality Estimation 2007 CIDR 8.9214171e-05
2,291 GORDIAN: Efficient and Scalable Discovery of Composite Keys 2006 VLDB 8.6872323e-05
2,891 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9021718e-05
2,987 Adapting to Source Properties in Processing Data Integration Queries 2004 SIGMOD 7.7773398e-05
3,210 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5363533e-05
3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.3760492e-05
3,367 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3719456e-05
4,106 Content-Based Routing: Different Plans for Different Data 2005 VLDB 6.8032891e-05
4,659 Automated Statistics Collection in DB2 UDB 2004 VLDB 6.4822228e-05
5,470 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 6.1182634e-05
5,582 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 6.0768264e-05
5,597 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0718206e-05
5,667 Enabling Incremental Query Re-Optimization 2016 SIGMOD 6.0458446e-05
5,865 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9659203e-05
6,208 Efficient Detection of Empty-Result Queries 2006 VLDB 5.8497045e-05
6,642 Mining and Indexing Graphs for Supergraph Search 2013 VLDB 5.7238453e-05
6,800 ROX: Run-time Optimization of XQueries 2009 SIGMOD 5.6792071e-05
6,818 ASM: Harmonizing Autoregressive Model, Sampling, and Multi-dimensional Statistics Merging for Cardinality Estimation 2024 SIGMOD 5.672718e-05
7,072 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 5.6074688e-05
7,410 POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance 2024 VLDB 5.5342768e-05
7,633 Consistent Histograms In The Presence of Distinct Value Counts 2009 VLDB 5.4792473e-05
8,289 Relational Support for Flexible Schema Scenarios 2008 VLDB 5.3614788e-05
9,718 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1353964e-05
9,845 Detecting Attribute Dependencies from Query Feedback 2007 VLDB 5.1213286e-05
10,294 Data-Agnostic Cardinality Learning from Imperfect Workloads 2025 VLDB 5.0431863e-05
10,308 Fast Approximate Computation of Statistics on Views 2006 SIGMOD 5.0400722e-05
10,982 A Portable Middleware for Plan-Based Adaptive Query Processing 2026 VLDB 4.9793485e-05
12,792 Filtered Statistics 2009 SIGMOD 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

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

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0023947656
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00047863192
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047731453
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034106982
103 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00033894985
118 The EXODUS Optimizer Generator 1987 SIGMOD 0.00031392616
119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.0003137356
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029627449
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028672526
272 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022509573
273 Extensible Query Processing in Starburst 1989 SIGMOD 0.00022504729
371 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019829769
378 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019549382
454 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017962189
553 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.0001652591
866 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013381261
935 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00012989395
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,516 Optimization of Queries with User-defined Predicates 1996 VLDB
2 4,415 Estimating Compilation Time of a Query Optimizer 2003 SIGMOD
3 272 An Overview of Query Optimization in Relational Systems 1998 PODS
4 149 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD
5 3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD
6 7,597 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD
7 682 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB
8 289 Optimization of Dynamic Query Evaluation Plans 1994 SIGMOD
9 1,131 Efficient Exploitation of Similar Subexpressions for Query Processing 2007 SIGMOD
10 3,133 Statistics on Views 2003 VLDB