Home » RDBMS Server » Performance Tuning » What are the steps to tune a query
What are the steps to tune a query [message #121472] Mon, 30 May 2005 02:03 Go to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Hi all,
What should be the steps to tune a query.I am just starting it.So experts please reply.I know only one step,explain plan.But what is cost and other parameters in the output.

Thanks and regards
Dinesh
Re: What are the steps to tune a query [message #121482 is a reply to message #121472] Mon, 30 May 2005 03:30 Go to previous messageGo to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
hi all,
i just want to know how can i know the performance is poor ,only by looking at the time taken by the database to give the result or any thing else.Please reply.

Thanks
Dinesh
Re: What are the steps to tune a query [message #121483 is a reply to message #121482] Mon, 30 May 2005 03:58 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/preface.htm#970501

Real good source for learning tuning...
Re: What are the steps to tune a query [message #121541 is a reply to message #121483] Mon, 30 May 2005 09:08 Go to previous message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Thanks a lot.
I just need this.

With regards
Dinesh
Previous Topic: Datawarehouse query
Next Topic: Oracle Server Information
Goto Forum:
  


Current Time: Tue Mar 19 05:18:46 CDT 2024