Predicates and SQL Tuning › Influencing the Optimizer

Influencing the Optimizer

The DB2 optimizer is good at picking the correct access path, when it is given the proper information. In situations where it does not pick the optimal access path, it typically does not have enough information. This is sometimes the case when you use parameter markers or host variables in a statement.