How I learned to stop worrying and love re-optimization

M Perron, Z Shang, T Kraska… - 2019 IEEE 35th …, 2019 - ieeexplore.ieee.org
M Perron, Z Shang, T Kraska, M Stonebraker
2019 IEEE 35th International Conference on Data Engineering (ICDE), 2019ieeexplore.ieee.org
Cost-based query optimizers remain one of the most important components of database
management systems for analytic workloads. Though modern optimizers select plans close
to optimal performance in the common case, a small number of queries are an order of
magnitude slower than they could be. In this paper we investigate why this is still the case,
despite decades of improvements to cost models, plan enumeration, and cardinality
estimation. We demonstrate why we believe that a re-optimization mechanism is likely the …
Cost-based query optimizers remain one of the most important components of database management systems for analytic workloads. Though modern optimizers select plans close to optimal performance in the common case, a small number of queries are an order of magnitude slower than they could be. In this paper we investigate why this is still the case, despite decades of improvements to cost models, plan enumeration, and cardinality estimation. We demonstrate why we believe that a re-optimization mechanism is likely the most cost-effective way to improve end-to-end query performance. We find that even a simple re-optimization scheme can improve the latency of many poorly performing queries. We demonstrate that re-optimization improves the end-to-end latency of the top 20 longest running queries in the Join Order Benchmark by 27%, realizing most of the benefit of perfect cardinality estimation.
ieeexplore.ieee.org
以上显示的是最相近的搜索结果。 查看全部搜索结果

Google学术搜索按钮

example.edu/paper.pdf
搜索
获取 PDF 文件
引用
References