Re: Indexes with LIKE statements

Craig, I now understand the request better (after talking to another developer who provided a better explanation of what was needed). Basically the searches wouldn't be done on this particular column requested to be indexed. Thus, to get any benefits, hints would be needed, as this column is not in the query so analyzing wouldn't provide the benefit.

Craig Kelley wrote:

> 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
Received on Thu Mar 23 2000 - 00:00:00 CST