SQL*PLUS and INDEX
From: gg <gianpaolo.giliberto_at_tiscalinet.it>
Date: Fri, 24 Nov 2000 16:11:25 +0100
Message-ID: <8vlvs1$rjs$1_at_lacerta.tiscalinet.it>
Date: Fri, 24 Nov 2000 16:11:25 +0100
Message-ID: <8vlvs1$rjs$1_at_lacerta.tiscalinet.it>
Hy,
[Quoted] 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 Fri Nov 24 2000 - 16:11:25 CET