ANL6018I *** RECOMMENDATION: THIS NONMATCHING INDEX SCAN ACCESS PATH MIGHT BE CAUSED BY THE ORING OF PREDICATES. WHEN OR DOES NOT CHOOSE MULTIPLE INDEX SCAN OR NON-MATCHING INDEX SCAN FOR STAGE 1 PREDICATES, IT MIGHT BE WORTH REWRITING THIS QUERY AS THE UNION OF SEVERAL STAGE 1 PREDS INSTEAD. CONSIDER THIS REWRITE TO AVOID THE TSCAN.