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: 10050
Venue: VLDB
Year: 2010
Pagerank: 6.1909336e-05
Overall Rank: 4,436 | 69.15%
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,022	DBSherlock: A Performance Diagnostic Tool for Transactional Databases	2016	SIGMOD	0.00014614917
1,534	PerfXplain: Debugging MapReduce Job Performance	2012	VLDB	0.00011468393
7,776	Plan Stitch: Harnessing the Best of Many Plans	2018	VLDB	4.6537231e-05
8,578	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB	4.4923477e-05
9,160	ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA	2020	SIGMOD	4.3849295e-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.0040449103
115	Eddies: Continuously Adaptive Query Processing	2000	SIGMOD	0.00046221215
132	The EXODUS Optimizer Generator	1987	SIGMOD	0.00042994082
182	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00036962631
252	Adaptive Selectivity Estimation Using Query Feedback	1994	SIGMOD	0.00030632263
424	Tuning Database Configuration Parameters with iTuned	2009	VLDB	0.00023616398
650	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.00018659177
684	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD	0.00018179769
1,272	Proactive Re-Optimization	2005	SIGMOD	0.00012920076
4,277	A Blackboard Architecture for Query Optimization in Object Bases	1993	VLDB	6.2959161e-05
5,668	A Pay-As-You-Go Framework for Query Execution Feedback	2008	VLDB	5.3806337e-05
8,016	User-Optimizer Communication using Abstract Plans in Sybase ASE	2001	VLDB	4.6050078e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
339	Optimization of Dynamic Query Evaluation Plans	1994	SIGMOD	0.00026851113
9,957	How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches	2025	VLDB	4.2373024e-05
5,340	Efficiently Approximating Query Optimizer Plan Diagrams	2008	VLDB	5.5623066e-05
132	The EXODUS Optimizer Generator	1987	SIGMOD	0.00042994082
1,962	Plan Selection based on Query Clustering	2002	VLDB	9.950467e-05
508	Dynamic Query Evaluation Plans	1989	SIGMOD	0.00021463742
9,662	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD	4.3097631e-05
10,219	Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking	2026	SIGMOD	4.1945683e-05
3,284	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.2790444e-05
1,070	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00014316791