Jev classification picks a join order in Michael Malis's query planner

Author: Michael Malis

Classification

Michael Malis

Classify this use case

  • Classification0.94
  • Shipped0.54
  • Measured0.68
  • Usefulness0.41
  • Community post1.00
  • Disagreeing fields0.49
  • Specific case0.51
  • Copy quality0.39
  • Creativity0.76
  • Distinct intent0.82
Result
12% faster on the join order benchmark

Ask Jev which join order this query should take.

Questions

Primitive

Choice

Ask a multiple choice question

Name
label
Instructions
Which join order should this query take? Pick the single best match.
Criteria
  • order_a

    The first offered join order.

  • order_b

    The second offered join order.

  • other

    Another legal join order.