OraFAQ Forum: Performance Tuning » How can I tell if an index is working

Home » RDBMS Server » Performance Tuning » How can I tell if an index is working

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

How can I tell if an index is working [message #365689]

Thu, 26 August 1999 18:21

m a sivan
Messages: 34
Registered: July 1999

Member

USING
SET AUTOTRACE ON
AND THEN RUNNING ALL THE QUERIES U CAN FIND OUT THAT TOOO

Report message to a moderator

Re: How can I tell if an index is working? [message #365694 is a reply to message #365689]

Fri, 03 September 1999 08:37

Jonathan Brandt
Messages: 1
Registered: September 1999

Junior Member

Try doing a tkprof...

alter session set sql_trace=true;
select ... from ... where...;
exit;

run tkprof over the trace file in user_dump_dest.

Looking at exucution plan will tell more about the index usage.

Jonathan

Report message to a moderator

Previous Topic:	How can I tell if an index is working?
Next Topic:	I/O configuaration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 04:21:26 CDT 2023