SQL*PLUS and INDEX

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 Fri Nov 24 2000 - 09:06:36 CST