mrvilas1's blog
Submitted by mrvilas1 on Fri, 2007-09-28 07:40
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.
|
