Tuning SQL LIKE using indexes

The SQL LIKE operator very often causes unexpected performance behavior because some search terms prevent efficient index usage. That means that there are search terms that can be indexed very well, but others can not. It is the position of the wild card characters that makes all the difference. The following example uses the % wild card in the middle of the search term: SELECT first_name, last_na

[equilibrista]

“Avoid LIKE expressions with leading wildcards (e.g., '%TERM').”