Improved predicate transformations

Db2 11 applies more techniques to transform query predicates for processing at earlier stages.

Db2 applies the following types of query transformations to make predicates eligible to be processed at earlier stages:

  • Addition of generated predicates
  • Removal of unneeded pre-evaluated predicates
  • Removal of unneeded table references in certain join predicates

Generally, you do not have to do anything to take advantage of the new query transformations.