A query was found to have its execution time out which contained the following clause:
( table.field IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) )
This IN clause was found to affect performance and it was determined that multiple operators were not allowed on index scans for an ANL join execution. Changes have been made to allow additional ANL predicates resulting in efficient index choices boosting performance.