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'