Re: Indexes with LIKE statements

Nikita <Nikita_at_yahoo.com> writes:

> Running Oracle 8.0.5 on Solaris 2.7
>
> Creating a b-tree index on a varchar2 column, with high cardinality data
>
> being searched with LIKE statements.
> Does this make sense, and would the use of this index need to be forced
> with hints?

The optimizer will use the index if your clause is

  like 'DATA%'

But it cannot use the index if your clause is

  like '%DATA'

-- 
The wheel is turning but the hamster is dead.
Craig Kelley  -- kellcrai_at_isu.edu
http://www.isu.edu/~kellcrai finger ink@inconnu.isu.edu for PGP block