Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to check if a query is using an index ?

Re: How to check if a query is using an index ?

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 22 Aug 2003 18:15:03 +0200
Message-ID: <3F464187.9070207@science-computing.de>


F.Marchioni wrote:
> 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
>
>

In addition to what the others stated: get familiar with tkprof. It gives you the actual plan that was executed where explain plan might deceive you. ( I presume we're not talking about FGAC here where it can get really weird ? )

HTH Holger Received on Fri Aug 22 2003 - 11:15:03 CDT

Original text of this message

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