Green Query Optimization: Taming Query Optimization Overheads through Plan Recycling

Summary: Extends PLASTIC, plan-recycling to amortize query optimization overheads via clustering queries and reusing a cluster plan. Adds an enhanced feature vector, variable-sized clustering, and a decision-tree classifier, demoed on IBM DB2 and Oracle 9i. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9289
Venue: VLDB
Year: 2004
Pagerank: 5.9048959e-05
Overall Rank: 6,350 | 56.44%
DOI: 10.1016/B978-012088469-8.50140-6

Incoming Non-self Citations Over Time

Authors

1. Parag Sarda (Indian Institute of Science)
2. Jayant R. Haritsa (Indian Institute of Science)

BibTeX Citation

@article{sarda_vldb04,
        title = {{Green Query Optimization: Taming Query Optimization Overheads through Plan Recycling}},
        author = {Sarda, Parag and Haritsa, Jayant R.},
        journal = {PVLDB},
        series = {{VLDB} '04},
        pages = {1333--1336},
        doi = {10.1016/B978-012088469-8.50140-6},
        url = {https://doi.org/10.1016/B978-012088469-8.50140-6},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
383	QPipe: A Simultaneously Pipelined Relational Query Engine	2005	SIGMOD	0.00019520728
984	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00012825643
8,703	Divergent Physical Design Tuning for Replicated Databases	2012	SIGMOD	5.3813751e-05
12,486	Visualizing the robustness of query execution	2009	CIDR	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 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,771	Plan Selection based on Query Clustering	2002	VLDB	9.7942089e-05
13,929	PLASTIC: Reducing Query Optimization Overheads through Plan Recycling	2003	SIGMOD	-

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,817	Efficiently Approximating Query Optimizer Plan Diagrams	2008	VLDB
2	1,987	Plan Bouquets: Query Processing without Selectivity Estimation	2014	SIGMOD
3	10,508	Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking	2026	SIGMOD
4	2,821	Towards Eco-friendly Database Management Systems	2009	CIDR
5	6,548	Query Optimization over Crowdsourced Data	2013	VLDB
6	7,655	Plan Stitch: Harnessing the Best of Many Plans	2018	VLDB
7	984	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB
8	5,281	Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees	2017	SIGMOD
9	1,771	Plan Selection based on Query Clustering	2002	VLDB
10	13,929	PLASTIC: Reducing Query Optimization Overheads through Plan Recycling	2003	SIGMOD