Accurate, efficiently computable cost functions are important for cost-based query optimizers. We investigate how to automatically find the best approximate cost functions minimizing the q-error for a hash join on measurements from extensive experiments. We systematically analyze which factors influence the approximation error, which input parameters are beneficial, and how this relates to plan quality in the big picture. From this, we derive suggestions for improvements for the query evaluation engine (QEE) that benefit both the hash join’s runtime and the approximation error.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

Made to Measure: Towards Approximability of Query Evaluation Engines

  • Daniel Flachs,
  • Guido Moerkotte

摘要

Accurate, efficiently computable cost functions are important for cost-based query optimizers. We investigate how to automatically find the best approximate cost functions minimizing the q-error for a hash join on measurements from extensive experiments. We systematically analyze which factors influence the approximation error, which input parameters are beneficial, and how this relates to plan quality in the big picture. From this, we derive suggestions for improvements for the query evaluation engine (QEE) that benefit both the hash join’s runtime and the approximation error.