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.00021214633 |
| 1,070 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB | 0.00014316791 |
| 8,272 | Divergent Physical Design Tuning for Replicated Databases | 2012 | SIGMOD | 4.5452316e-05 |
| 12,291 | Visualizing the robustness of query execution | 2009 | CIDR | 4.1945683e-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,962 | Plan Selection based on Query Clustering | 2002 | VLDB | 9.950467e-05 |
| 13,728 | 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,340 | Efficiently Approximating Query Optimizer Plan Diagrams | 2008 | VLDB | 5.5623066e-05 |
| 2,631 | Plan Bouquets: Query Processing without Selectivity Estimation | 2014 | SIGMOD | 8.4101843e-05 |
| 10,219 | Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking | 2026 | SIGMOD | 4.1945683e-05 |
| 6,806 | Query Optimization over Crowdsourced Data | 2013 | VLDB | 4.9218336e-05 |
| 1,834 | Towards Eco-friendly Database Management Systems | 2009 | CIDR | 0.00010376345 |
| 1,070 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB | 0.00014316791 |
| 7,776 | Plan Stitch: Harnessing the Best of Many Plans | 2018 | VLDB | 4.6537231e-05 |
| 6,479 | Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees | 2017 | SIGMOD | 5.0483805e-05 |
| 1,962 | Plan Selection based on Query Clustering | 2002 | VLDB | 9.950467e-05 |
| 13,728 | PLASTIC: Reducing Query Optimization Overheads through Plan Recycling | 2003 | SIGMOD | - |