Sample Analysis Report

Warnings AW55 and AW92 are derived from the explain results. Explain however does not tell why the expression is not keymatching.

Predicate analysis goes beyond EXPLAIN by showing why the expression is not sargable and therefore, not keymatching (warning AW01).


To obtain more details about warning AW01, position the cursor on the warning message and press PF1. This shows the Glossary entry for this message.