Look up EXPLAIN PLAN in the docs
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"F.Marchioni" <fmarchioniNIENTESPAM_at_libero.it> wrote in message
news:D0j1b.257242$lK4.7949932_at_twister1.libero.it...
> Dear all,
> I'd like to know if there's a way to check if a query is -actually- using
an
> index.
> I've read that Oracle is able to evaluate what's better between a full
table
> scan and using an index (true?)....so I'd like to know when the first
> solution
> is chosen...
> Thanks a lot in advance
> Francesco
>
>
Received on Fri Aug 22 2003 - 03:05:38 CDT
