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)
Incoming Non-self Citations Over Time
Authors
- 1. Parag Sarda
- 2. Jayant R. Haritsa
Incoming Citations (Sorted by Pagerank)
Showing 4 of 4 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 515 | QPipe: A Simultaneously Pipelined Relational Query Engine | 2005 | SIGMOD | 0.00021209491 |
| 1,064 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB | 0.00014348262 |
| 8,268 | Divergent Physical Design Tuning for Replicated Databases | 2012 | SIGMOD | 4.5408509e-05 |
| 12,299 | Visualizing the robustness of query execution | 2009 | CIDR | 4.1905499e-05 |
Previous
Page 1 / 1
Next
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,961 | Plan Selection based on Query Clustering | 2002 | VLDB | 9.9464221e-05 |
| 13,742 | PLASTIC: Reducing Query Optimization Overheads through Plan Recycling | 2003 | SIGMOD | - |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 5,344 | Efficiently Approximating Query Optimizer Plan Diagrams | 2008 | VLDB | 5.5579641e-05 |
| 2,632 | Plan Bouquets: Query Processing without Selectivity Estimation | 2014 | SIGMOD | 8.4153283e-05 |
| 10,219 | Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking | 2026 | SIGMOD | 4.1905499e-05 |
| 1,832 | Towards Eco-friendly Database Management Systems | 2009 | CIDR | 0.0001036671 |
| 6,801 | Query Optimization over Crowdsourced Data | 2013 | VLDB | 4.9175463e-05 |
| 1,064 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB | 0.00014348262 |
| 7,776 | Plan Stitch: Harnessing the Best of Many Plans | 2018 | VLDB | 4.6493147e-05 |
| 6,471 | Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees | 2017 | SIGMOD | 5.0438582e-05 |
| 1,961 | Plan Selection based on Query Clustering | 2002 | VLDB | 9.9464221e-05 |
| 13,742 | PLASTIC: Reducing Query Optimization Overheads through Plan Recycling | 2003 | SIGMOD | - |