Tip - PL/SQL Performance Tuning for LIKE '%...%' Wildcard Queries

We're using Oracle 11g database. As you may or may not know, if you use wildcard query with "%" in front of the string, the column index is not being used and a full table scan is happening. It l...