OraFAQ Forum: Performance Tuning » Check if the Index is performing good or not

Home » RDBMS Server » Performance Tuning » Check if the Index is performing good or not

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

Check if the Index is performing good or not [message #191091]

Mon, 04 September 2006 09:02

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

Report message to a moderator

Re: Check if the Index is performing good or not [message #191096 is a reply to message #191091]

Mon, 04 September 2006 10:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

EXPLAIN PLAN

Report message to a moderator

Re: Check if the Index is performing good or not [message #191254 is a reply to message #191096]

Tue, 05 September 2006 07:30

bahy91
Messages: 91
Registered: September 2005
Location: Amsterdam

Member

thanks..
Is there is anything els?!

Report message to a moderator

Re: Check if the Index is performing good or not [message #191259 is a reply to message #191254]

Tue, 05 September 2006 07:35

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

tkprof

Report message to a moderator

Re: Check if the Index is performing good or not [message #191261 is a reply to message #191254]

Tue, 05 September 2006 07:36

rleishman
Messages: 3728
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

Report message to a moderator

Previous Topic:	Performance tuning SQL
Next Topic:	analyze table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 13:29:37 CST 2024