Oracle SQL "like clause" and index access

Indexing when using the SQL "like" clause can be tricky because the wildcard "%" operator can invalidate the index. For example a last_name index would be OK with a "like 'SMI%'" query, but unusable with "like '%SMI%'. Solutions to this issue of a leading

www.dba-oracle.com