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.

Subscribe to RSS - mrvilas1's blog