Skip navigation.

mrvilas1's blog

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

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.