comparing CHAR to VARCHAR, or INTEGER to DECIMAL, forces DB2 to apply a function, which kills index matching 2. **Expression on the column side** — `WHERE YEAR(TRANS_DATE) = 2025` cannot match an index on TRANS_DATE 3. **OR predicates** — `WHERE ACCT_TYPE = 'C' OR ACCT_TYPE = 'S'` may reduce MATCHCO