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: h722879a0457731ff
Venue: VLDB
Year: 2004
Pagerank: 5.7769157e-05
Overall Rank: 6,460 | 56.57%
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
389	QPipe: A Simultaneously Pipelined Relational Query Engine	2005	SIGMOD	0.00019269777
996	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00012634603
8,865	Divergent Physical Design Tuning for Replicated Databases	2012	SIGMOD	5.2618746e-05
12,777	Visualizing the robustness of query execution	2009	CIDR	4.9793485e-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,789	Plan Selection based on Query Clustering	2002	VLDB	9.6293635e-05
14,240	PLASTIC: Reducing Query Optimization Overheads through Plan Recycling	2003	SIGMOD	-

Semantically Similar Papers

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