Optimization of queries has been improved by evaluating simple predicates before the optimizer selects a query plan, including join ordering, join algorithm selection, and grouping algorithm selection. A new database option EARLY_PREDICATE_EXECUTION controls whether simple local predicates are executed before query optimization. For more information, see “EARLY_PREDICATE_EXECUTION option” in Chapter 2, “Database Options” of the Sybase IQ Reference Manual.
