• Sergey Petrunia's avatar
    MWL#17: Table elimination · 275a4b35
    Sergey Petrunia authored
    - First code. Elimination works for simple cases, passes the testsuite.
    - Known issues:
      = No elimination is done for aggregate functions.
      = EXPLAIN EXTENDED shows eliminated tables (I think it better not)
      = No benchmark yet
      = The code needs some polishing.
    
    mysql-test/r/table_elim.result:
      MWL#17: Table elimination
      - Testcases
    mysql-test/t/table_elim.test:
      MWL#17: Table elimination
      - Testcases
    sql/sql_select.cc:
      MWL#17: Table elimination
    sql/sql_select.h:
      MWL#17: Table elimination
      - Added JOIN_TAB::eliminated (is JOIN_TAB the best place to store this flag?)
    sql/table.h:
      MWL#17: Table elimination
      - ADded NESTED_JOIN::n_tables. We need to have the number of real tables remaining in an outer join nest.
    275a4b35
table_elim.test 1.57 KB