Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Preprint |
| Published: |
2024
|
| Subjects: | |
| Online Access: | https://arxiv.org/abs/2406.01526 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1866909256388706304 |
|---|---|
| author | Xiu, Haibo Agarwal, Pankaj K. Yang, Jun |
| author_facet | Xiu, Haibo Agarwal, Pankaj K. Yang, Jun |
| contents | The effectiveness of a query optimizer relies on the accuracy of selectivity estimates. The execution plan generated by the optimizer can be extremely poor in reality due to uncertainty in these estimates. This paper presents PARQO (Penalty-Aware Robust Plan Selection in Query Optimization), a novel system where users can define powerful robustness metrics that assess the expected penalty of a plan with respect to true optimal plans under uncertain selectivity estimates. PARQO uses workload-informed profiling to build error models, and employs principled sensitivity analysis techniques to identify human-interpretable selectivity dimensions with the largest impact on penalty. Experiments on three benchmarks demonstrate that PARQO finds robust, performant plans, and enables efficient and effective parametric optimization. |
| format | Preprint |
| id |
arxiv_https___arxiv_org_abs_2406_01526 |
| institution | arXiv |
| publishDate | 2024 |
| record_format | arxiv |
| spellingShingle | PARQO: Penalty-Aware Robust Plan Selection in Query Optimization Xiu, Haibo Agarwal, Pankaj K. Yang, Jun Databases The effectiveness of a query optimizer relies on the accuracy of selectivity estimates. The execution plan generated by the optimizer can be extremely poor in reality due to uncertainty in these estimates. This paper presents PARQO (Penalty-Aware Robust Plan Selection in Query Optimization), a novel system where users can define powerful robustness metrics that assess the expected penalty of a plan with respect to true optimal plans under uncertain selectivity estimates. PARQO uses workload-informed profiling to build error models, and employs principled sensitivity analysis techniques to identify human-interpretable selectivity dimensions with the largest impact on penalty. Experiments on three benchmarks demonstrate that PARQO finds robust, performant plans, and enables efficient and effective parametric optimization. |
| title | PARQO: Penalty-Aware Robust Plan Selection in Query Optimization |
| topic | Databases |
| url | https://arxiv.org/abs/2406.01526 |