Queries using the LIKE operator typically result in a full table scan. When the LIKE operator matches from the left, ...

Optimizing Queries with LIKE Operator in Teradata