[prev] 19 [next]

Top-down Trace of QOpt (cont)

make_one_rel() generates possible plans, selects best

  • generate scan and index paths for base tables
    • using of restrictions list generated above
  • generate access paths for the entire join tree
    • recursive process, controlled by make_rel_from_joinlist()
  • returns a single "relation", representing result set
Code in: backend/optimizer/path/allpaths.c