Predicates that DB2 generates

DB2® might generate certain predicates to improve access path selection.

The goal of most generated predicates is to increase the likelihood that DB2 can select more efficient and index-based access paths for a query. DB2 generates these predicates automatically, and you generally do not need to take action to benefit from them. However, you might notice the additional predicates in EXPLAIN output, and when you use query tuning tools to view access path diagrams or formatted query text.

DB2 might remove either the generated predicate or the original predicate if it is not required for the selected access path.

DB2 might generate additional predicates when it encounters the following types of situations:

Predicate through transitive closure

DB2 might generate additional predicates through transitive closure to improve access path efficiency. Transitive closure occurs when several predicates taken in combination logically imply the existence of additional predicates. Because those implied predicates might enable the selection of a more efficient access path, DB2 might generate such predicates.