You can use the DB2 EXPLAIN statement to determine the access paths for the SELECT parts of your statements. DB2…