Re: SQL*PLUS and INDEX

Yes, you are....

gg <gianpaolo.giliberto_at_tiscalinet.it> wrote in message news:8vlvj1$rcp$1_at_lacerta.tiscalinet.it...
> Hy,
> we have a table k with a index on 3 fields
> (x,y,z in this order) and
> sometime we have to execute a query like this:
>
> select ..
> from k
> where
> x in (select ... from ....) and
> y=.. and
> z=.....;
>
> Do we use the index with this query ?
>
> Thanks.
> Goodbye
> gianpaolo.giliberto_at_tiscalinet.it
>
>
Received on Wed Nov 29 2000 - 10:33:01 CST