OraFAQ Forum: Server Administration » indexes and tablescan how to

Home » RDBMS Server » Server Administration » indexes and tablescan how to

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

indexes and tablescan how to [message #53305]

Wed, 11 September 2002 12:30

Lena
Messages: 17
Registered: August 2002

Junior Member

Hi there
Can someone please tell me which is the syntax for oracle to see what is the table doing
a tablescan or indexes, I have tried select * from ... indexes but is not much help
Thanks
Lena

Report message to a moderator

Re: indexes and tablescan how to [message #53307 is a reply to message #53305]

Wed, 11 September 2002 13:11

Eric Myers
Messages: 13
Registered: August 2002

Junior Member

See my answer on utilities board.

Report message to a moderator

Re: indexes and tablescan how to [message #53309 is a reply to message #53305]

Wed, 11 September 2002 20:50

K.K. Raj kumar
Messages: 33
Registered: July 2002

Member

You can use EXPLAIN PLAN to see how Oracle is executing a particular Select statement.

Report message to a moderator

Previous Topic:	Re: certification guide -8/8i/9i
Next Topic:	Oracle Instance Termination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 12:05:20 CDT 2024