DBScholar

Back to papers

Efficient Query Re-optimization with Judicious Subquery Selections

Summary: QuerySplit re-optimization generates subqueries from the logical plan, not the global plan. A cost function favors small, low-damage subqueries to delay large joins; in PostgreSQL, it yields 35% faster JOB vs baselines, within 4% of optimal. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hb060cf953cc6907d
Venue
SIGMOD
Year
2023
Pagerank
5.3649397e-05
Overall Rank
8,188 | 45.12%
DOI
10.1145/3589330

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zhao_sigmod23,
        title = {{Efficient Query Re-optimization with Judicious Subquery Selections}},
        author = {Zhao, Junyi and Zhang, Huanchen and Gao, Yihan},
        series = {{SIGMOD} '23},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3589330},
        url = {https://dl.acm.org/doi/10.1145/3589330},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank Citing Paper Year Venue Pagerank
4,971 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.3209003e-05
6,840 ASM: Harmonizing Autoregressive Model, Sampling, and Multi-dimensional Statistics Merging for Cardinality Estimation 2024 SIGMOD 5.6513231e-05
7,169 Cost-Intelligent Data Analytics in the Cloud 2024 CIDR 5.5789764e-05
10,339 Data Chunk Compaction in Vectorized Execution 2025 SIGMOD 5.0210286e-05
10,347 Intra-Query Runtime Elasticity for Cloud-Native Data Analysis 2025 SIGMOD 5.0195882e-05
10,370 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.0010514e-05
11,052 A Portable Middleware for Plan-Based Adaptive Query Processing 2026 VLDB 4.9605343e-05
11,454 Accordion: Balancing Performance and Cost in Cloud-Native Data Analysis with Intra-Query Runtime Elasticity 2025 VLDB 4.9605343e-05
11,633 Blitzcrank: Fast Semantic Compression for In-memory Online Transaction Processing 2024 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 29 of 29 cited papers.

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

Rank Cited Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061463175
53 Eddies: Continuously Adaptive Query Processing 2000 SIGMOD 0.00040739114
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
91 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00034691614
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
142 Neo: A Learned Query Optimizer 2019 VLDB 0.00029114937
149 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00028910892
259 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022881075
320 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021128745
405 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019020138
453 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001801482
471 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.00017691682
508 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017108973
689 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR 0.00014725904
1,061 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012207625
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012181459
1,156 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011759683
1,261 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011289724
1,444 Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities 2019 SIGMOD 0.00010616242
1,511 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010408003
1,513 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010394557
1,583 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010148362
2,523 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3316032e-05
3,212 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5145409e-05
3,282 Estimating Cardinalities with Deep Sketches 2019 SIGMOD 7.4491295e-05
3,995 Simplicity Done Right for Join Ordering 2021 CIDR 6.8530469e-05
4,069 Adaptive Query Processing in the Looking Glass 2005 CIDR 6.8080574e-05
6,128 Robustness Metrics for Relational Query Execution Plans 2018 VLDB 5.860258e-05
7,619 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD 5.4665491e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,185 Adaptive Optimization of Very Large Join Queries 2018 SIGMOD
2 1,137 Efficient Exploitation of Similar Subexpressions for Query Processing 2007 SIGMOD
3 1,261 Sampling-Based Query Re-Optimization 2016 SIGMOD
4 149 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD
5 3,807 Query Simplification: Graceful Degradation for Join-Order Optimization 2009 SIGMOD
6 5,446 Efficient Massively Parallel Join Optimization for Large Queries* 2022 SIGMOD
7 15 How Good Are Query Optimizers, Really? 2016 VLDB
8 10,181 How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches 2025 VLDB
9 3,785 Parallelizing Query Optimization 2008 VLDB
10 3,156 Query Optimization Techniques for Partitioned Tables 2011 SIGMOD