Xplus: A SQL-Tuning-Aware Query Optimizer

Summary: First SQL-tuning aware optimizer offers delta%-better plans for recurring queries via proactive subplan execution, monitoring, and iterative refinement. Extensible architecture with SQL-tuning experts and arbitration policy; evaluated on TPC-H workloads in PostgreSQL. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10051
Venue: VLDB
Year: 2010
Pagerank: 6.1851729e-05
Overall Rank: 4,434 | 69.19%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Herodotos Herodotou
2. Shivnath Babu

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,024	DBSherlock: A Performance Diagnostic Tool for Transactional Databases	2016	SIGMOD	0.00014601525
1,533	PerfXplain: Debugging MapReduce Job Performance	2012	VLDB	0.00011462982
7,776	Plan Stitch: Harnessing the Best of Many Plans	2018	VLDB	4.6493147e-05
8,575	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB	4.4880409e-05
9,160	ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA	2020	SIGMOD	4.380727e-05

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 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.0040465394
116	Eddies: Continuously Adaptive Query Processing	2000	SIGMOD	0.00046191288
134	The EXODUS Optimizer Generator	1987	SIGMOD	0.00043070028
181	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00036970794
250	Adaptive Selectivity Estimation Using Query Feedback	1994	SIGMOD	0.00030640525
423	Tuning Database Configuration Parameters with iTuned	2009	VLDB	0.00023628474
650	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.0001865144
680	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD	0.00018193263
1,268	Proactive Re-Optimization	2005	SIGMOD	0.00012914584
4,274	A Blackboard Architecture for Query Optimization in Object Bases	1993	VLDB	6.290327e-05
5,676	A Pay-As-You-Go Framework for Query Execution Feedback	2008	VLDB	5.3768269e-05
8,020	User-Optimizer Communication using Abstract Plans in Sybase ASE	2001	VLDB	4.6005954e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
342	Optimization of Dynamic Query Evaluation Plans	1994	SIGMOD	0.00026836424
9,956	How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches	2025	VLDB	4.2332427e-05
5,344	Efficiently Approximating Query Optimizer Plan Diagrams	2008	VLDB	5.5579641e-05
134	The EXODUS Optimizer Generator	1987	SIGMOD	0.00043070028
1,961	Plan Selection based on Query Clustering	2002	VLDB	9.9464221e-05
509	Dynamic Query Evaluation Plans	1989	SIGMOD	0.00021463676
9,662	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD	4.3056334e-05
10,219	Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking	2026	SIGMOD	4.1905499e-05
3,276	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.2880761e-05
1,064	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00014348262