Re: SQL*PLUS and INDEX

From: <aqs472_at_my-deja.com>
Date: Fri, 01 Dec 2000 16:51:22 GMT
Message-ID: <908ku6$ee0$1@nnrp1.deja.com>

You may be using your index on table k (but do an explain to be sure) although, I believe you will be doing a full table scan on your (select ... from ....) table.

In article <8vlvj1$rcp$1_at_lacerta.tiscalinet.it>, "gg" <gianpaolo.giliberto_at_tiscalinet.it> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 01 2000 - 10:51:22 CST