Database Paper Browser

Back to papers

To Tune or not to Tune? A Lightweight Physical Design Alerter

Summary: Lightweight alerter for physical design, providing guaranteed lower and upper bounds on the potential improvement from full tuning. It also delivers a proof-like recommendation to justify the bound and guides DBAs on whether to invoke expensive tuning tools, with low overhead and scalable workloads. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
9464
Venue
VLDB
Year
2006
Pagerank
8.1263608e-05
Overall Rank
2,787 | 80.62%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 19 of 19 citing papers.

Rank Citing Paper Year Venue Pagerank
1,343 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012482538
1,611 Qd-tree: Learning Data Layouts for Big Data Analytics 2020 SIGMOD 0.00011147324
1,758 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00010655546
2,229 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.2350274e-05
2,367 Here are my Data Files. Here are my Queries. Where are my Results? 2011 CIDR 8.9511058e-05
2,484 Efficient Use of the Query Optimizer for Automated Physical Design 2007 VLDB 8.6864279e-05
3,072 Constrained Physical Design Tuning 2008 VLDB 7.6114086e-05
3,284 Configuration-Parametric Query Optimization for Physical Design Tuning 2008 SIGMOD 7.2790444e-05
3,488 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.0479329e-05
4,506 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 6.1319277e-05
4,729 Workload Matters: Why RDF Databases Need a New Design 2014 VLDB 5.9675136e-05
5,924 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 5.2719183e-05
6,366 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 5.0943443e-05
6,398 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 5.0819209e-05
7,010 QueryScope: Visualizing Queries for Repeatable Database Tuning 2008 VLDB 4.8634875e-05
7,776 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 4.6537231e-05
8,041 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 4.5998045e-05
9,929 Wred: Workload Reduction for Scalable Index Tuning 2024 SIGMOD 4.2510122e-05
12,403 When is it Time to Rethink the Aggregate Configuration of Your OLAP Server? 2008 VLDB 4.1945683e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 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.0040449103
158 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00040071492
237 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00031726304
258 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.0003022091
496 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.00021728655
516 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00021196031
661 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00018481174
1,017 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014634307
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
6,520 Foundations of Automated Database Tuning 2006 VLDB 5.0307595e-05
661 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00018481174
3,812 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 6.7373184e-05
1,006 A Framework for Automating Physical Database Design 1991 VLDB 0.00014688178
7,445 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD 4.7278675e-05
2,828 Automatic Physical Design Tuning: Workload as a Sequence 2006 SIGMOD 8.0548516e-05
12,450 Online AutoAdmin (Physical Design Tuning) 2007 SIGMOD 4.1945683e-05
3,284 Configuration-Parametric Query Optimization for Physical Design Tuning 2008 SIGMOD 7.2790444e-05
3,072 Constrained Physical Design Tuning 2008 VLDB 7.6114086e-05
1,017 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014634307