Home » RDBMS Server » Performance Tuning » Check if the Index is performing good or not
Check if the Index is performing good or not [message #191091] Mon, 04 September 2006 09:02 Go to next message
bahy91
Messages: 91
Registered: September 2005
Location: Amsterdam
Member
Hi All,
Which Tool or utility can people use to determine the performance and the execution time of the query on a table regarding the use of an Index.?

Thank You
Re: Check if the Index is performing good or not [message #191096 is a reply to message #191091] Mon, 04 September 2006 10:10 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
EXPLAIN PLAN
Re: Check if the Index is performing good or not [message #191254 is a reply to message #191096] Tue, 05 September 2006 07:30 Go to previous messageGo to next message
bahy91
Messages: 91
Registered: September 2005
Location: Amsterdam
Member
thanks..
Is there is anything els?!
Re: Check if the Index is performing good or not [message #191259 is a reply to message #191254] Tue, 05 September 2006 07:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
tkprof
Re: Check if the Index is performing good or not [message #191261 is a reply to message #191254] Tue, 05 September 2006 07:36 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Explain Plan tells you whether it will use an index, not how it will perform. There is only one way to do that: run it. You can get objective measures of performance by using SQL*Trace and TK*Prof - see the Performance Tuning Manual for more info.

Ross Leishman
Previous Topic: Performance tuning SQL
Next Topic: analyze table
Goto Forum:
  


Current Time: Thu Dec 08 04:04:50 CST 2016

Total time taken to generate the page: 0.12213 seconds