Why is this an issue?
When the value of a LIKE
clause starts with '%', '[…]' or '_', indexes on the searched column are ignored, and a full table scan is
performed instead.
Noncompliant code example
SELECT FIRST_NAME, LAST_NAME FROM PERSONS
WHERE LAST_NAME LIKE '%PONT'