The following terms are used in this section:
join clause – the clause that joins tables. Here is an example:
select * from tableA, tableB where tableA.col = tableB.col
join transitive closure allows the optimizer to consider a join order other than those made available explicitly by the query’s where clause.
optdiag - A command-line tool for reading, writing, and simulating table, index, and column statistics.
query – Any SQL statement, such as a batch query, the SQL content of a stored procedure or trigger, or the SQL that is used to create a view (view definition).
SARG- A predicate in the query’s where clause that qualifies the rows to be returned. Here is an example:
select * from stores where store_id = "4914"
