Tuning a 'LIKE-clause' by using Oracle Text or Reverse Key Indexes | Oracle FAQ

The LIKE-clause can ignore indexes, causing queries to run forever while doing full table scans. This document describes how to tune such SQL statements by making use of Oracle Text or reverse key indexes. Tuning the ‘LIKE’ Clause: Generally, search ...

www.orafaq.com