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

<g>
I see you are freaking out in this newsgroup by posting junk messages. Are we having fun yet?

Try doing:
select decode(mod(dbms_random.random,2),-1,'Yes',0,'Maybe','No') from dual;

to figure out if your query is doing index scan or not. You should get a yes or no or maybe. Repeat until you get yes.

.. or

try
set autotrace traceonly explain
query
set autotrace off

... or search on web as to how to generate an explain plan.

Anurag

"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
Received on Wed Sep 11 2002 - 21:05:44 CDT