Query optimization through the looking glass, and what we found running the Join Order Benchmark

@article{Leis2017QueryOT,
  title={Query optimization through the looking glass, and what we found running the Join Order Benchmark},
  author={Viktor Leis and Bernhard Radke and Andrey Gubichev and Atanas Mirchev and Peter A. Boncz and Alfons Kemper and Thomas Neumann},
  journal={The VLDB Journal},
  year={2017},
  pages={1-26}
}
Finding a good join order is crucial for query performance. In this paper, we introduce the Join Order Benchmark that works on real-life data riddled with correlations and introduces 113 complex join queries. We experimentally revisit the main components in the classic query optimizer architecture using a complex, real-world data set and realistic multi… CONTINUE READING