DB2 Predicates

DB2 Predicates : Performance Tuning of DB2 Queries

The DB2 Predicates affect how DB2 selects the access path for the statement. Predicates are found in the WHERE, HAVING, or ON clauses of SQL statements; they describe attributes of data. Most DB2 predicates are based on the columns of a table. They either qualify rows (through an index) or reject rows (returned by a […]

DB2 Predicates : Performance Tuning of DB2 Queries Read More »