How to check if a query is using an index ?

From: F.Marchioni <fmarchioniNIENTESPAM_at_libero.it>
Date: Fri, 22 Aug 2003 06:48:03 GMT
Message-ID: <D0j1b.257242$lK4.7949932@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 - 01:48:03 CDT

This message: [ Message body ]
Next message: F.Marchioni: "What are the implications of a Library Cache Hit Ratio low ?"
Previous message: F.Marchioni: "How to optimize query with %% ?"
Next in thread: Niall Litchfield: "Re: How to check if a query is using an index ?"
Reply: Niall Litchfield: "Re: How to check if a query is using an index ?"
Reply: Billy Verreynne: "Re: How to check if a query is using an index ?"
Reply: Austin: "Re: How to check if a query is using an index ?"
Reply: Tim Kearsley: "Re: How to check if a query is using an index ?"
Reply: Holger Baer: "Re: How to check if a query is using an index ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US