Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Done
Description
The "How Good Are Query Optimizers, Really?" paper examined query optimizer behavior for a number of queries.
The queries are available here https://github.com/gregrahn/join-order-benchmark
(TiDB variant: https://github.com/winkyao/join-order-benchmark )
Some facts about the workload:
- The queries are N-way inner joins (no outer joins, or subqueries, or ORDER BY LIMIT)
- The indexes are single-component keys.
- The available indexes are "join indexes" for FK/PK relationships.
- The predicates are "simple ranges", possibly OR-ed
A script that [almost] automates the benchmark run:
https://github.com/spetrunia/join-order-benchmark-tool