The DB2 Predicates affect how DB2 selects the access path for the statement. Predicates are found in the WHERE, HAVING,…