Dynamic Plan Generation for Parameterized Queries
Summary: PQs admit generic (param-independent) vs specific (param-dependent) plans. A hybrid rule- and cost-based framework dynamically chooses between them at runtime, balancing cache, maintenance, skew, and rewrite effects; Teradata 12.0. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Ahmad Ghazal (Teradata)
- 2. Dawit Seid (Teradata)
- 3. Ramesh Bhashyam (Teradata)
- 4. Alain Crolotte (Teradata)
- 5. Manjula Koppuravuri (Teradata)
- 6. Vinod G (Teradata)
BibTeX Citation
@inproceedings{ghazal_sigmod09,
title = {{Dynamic Plan Generation for Parameterized Queries}},
author = {Ghazal, Ahmad and Seid, Dawit and Bhashyam, Ramesh and Crolotte, Alain and Koppuravuri, Manjula and G, Vinod},
series = {{SIGMOD} '09},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/1559845.1559946},
url = {https://dl.acm.org/doi/10.1145/1559845.1559946},
year = {2009}
}Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 5,281 | Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees | 2017 | SIGMOD | 6.2842378e-05 |
| 5,394 | Leveraging Query Logs and Machine Learning for Parametric Query Optimization | 2022 | VLDB | 6.2336084e-05 |
| 10,235 | EPSC: Testing Database Management Systems via Equivalent Prepared Statement Construction | 2026 | SIGMOD | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 5 of 5 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 151 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD | 0.00029161879 |
| 289 | Optimization of Dynamic Query Evaluation Plans | 1994 | SIGMOD | 0.00022278876 |
| 492 | Robust Query Processing through Progressive Optimization | 2004 | SIGMOD | 0.0001756877 |
| 5,770 | Closing The Query Processing Loop in Oracle 11g | 2008 | VLDB | 6.0934173e-05 |
| 6,117 | Proactive Re-optimization with Rio | 2005 | SIGMOD | 5.9706217e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 3,003 | Configuration-Parametric Query Optimization for Physical Design Tuning | 2008 | SIGMOD |
| 2 | 3,513 | Variance Aware Optimization of Parameterized Queries | 2010 | SIGMOD |
| 3 | 4,817 | Efficiently Approximating Query Optimizer Plan Diagrams | 2008 | VLDB |
| 4 | 5,394 | Leveraging Query Logs and Machine Learning for Parametric Query Optimization | 2022 | VLDB |
| 5 | 1,470 | Design and Analysis of Parametric Query Optimization Algorithms | 1998 | VLDB |
| 6 | 5,281 | Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees | 2017 | SIGMOD |
| 7 | 5,000 | Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling | 2021 | VLDB |
| 8 | 474 | Dynamic Query Evaluation Plans | 1989 | SIGMOD |
| 9 | 984 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB |
| 10 | 289 | Optimization of Dynamic Query Evaluation Plans | 1994 | SIGMOD |