View previous topic :: View next topic
|
Author |
Message |
meenakshi_forum Warnings : 1 Active User
Joined: 27 May 2008 Posts: 121 Location: India
|
|
|
|
Hello everybody!
I need to learn about query tuning, please guide me to learn it,
is there any manual for it?
Would appreciate if someone can give me some SQL examples of Query
tuning. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
is there any manual for it? |
Not that i'm aware of.
Tuning a query is much like tuning anything else. Determnine where the resources are being used and reduce this where possible. Sometimes this requires a complete redesign of the query or process as well as database modifications.
Suggest you talk with your dba to learn what is available for you to use to research. There is always EXPLAIN. |
|
Back to top |
|
|
skkp2006
New User
Joined: 14 Jul 2006 Posts: 93 Location: Chennai,India
|
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
Back to top |
|
|
|