Page History
...
- All SQL Optimizer hint-based variations that can be applied to a statement.
- A transformation-based case, if any of the eight common quick fixes can be applied to an SQL statement. This feature leverages the DB Optimizer Code Quality Check functionality. See Understanding Code Quality Checks for more information on the eight quick fixes. A transformation case, in turn, has its own set of SQL Optimizer hint cases. For information on query rewrites, see DB2, Oracle, SQL Server, Sybase Query Rewrites. For information on other transformations, see Examples of Transformations transformations and SQL Query Rewritesquery rewrites.
- SQL Query Rewrites may be suggested when tuning. For example, a recommended rewrite for EXISTS may be IN. For information on query rewrites, see DB2, Oracle, SQL Server, Sybase Query Rewrites.
...