table optimizer lookup table optimizer Free Download For a join statement that joins more than two tables, the optimizer chooses which pair of tables is joined first, and then which table is joined to the result, and so on.. By clicking download, you agree to the SentryOne Privacy Policy and End User ... each table and worktable involved in the plan, as well as the scan count per table. ... unde..