for example, a function applied to the indexed column (`WHERE YEAR(TRANS_DATE) = 2025`), a LIKE pattern with a leading wildcard (`WHERE CUST_NAME LIKE '%Smith'`), or an OR condition that cannot be converted to an IN list - **Statistics are stale or missing**, causing the optimizer to underestimate t