Home » RDBMS Server » Performance Tuning » How can I tell if an index is working
How can I tell if an index is working [message #365689] Thu, 26 August 1999 18:21 Go to next message
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
Re: How can I tell if an index is working? [message #365694 is a reply to message #365689] Fri, 03 September 1999 08:37 Go to previous message
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
Previous Topic: How can I tell if an index is working?
Next Topic: I/O configuaration
Goto Forum:
  


Current Time: Thu Mar 28 03:40:28 CDT 2024