Re: how do I see if a table is using indexes or scan

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 12 Sep 2002 09:20:38 +0100
Message-ID: <3d804e55$0$1294$cc9e4d1f@news.dial.pipex.com>

"Teresa" <tpreto7_at_sapo.pt> wrote in message news:6dabc692.0209111709.3682dd88_at_posting.google.com...
> Hi
> I'm new to the group I have a question:
> I have a table in which I would like to see if is doing a tablescan or
> index, can someone please tell me the syntax for this sql its in
> oracle 8i, I have a script that runs and for some reason it gets stuck
> at this specific table, so I would like to see is is using indexes or
> a tablescan
> any help would be great
> Thanks
> Teresa

look into autotrace in sqlplus. How do you know it is 'getting stuck' at this particular table?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

Received on Thu Sep 12 2002 - 03:20:38 CDT