|
View previous topic :: View next topic
|
| Author |
Message |
sakthivel_t100
Warnings : 1
New User
Joined: 03 Aug 2007
Posts: 10
Location: chennai
|
|
|
|
Hi All,
I need one help.
I have faced below question on Interview panel.
How do we know query tunning or not in DB2?
Thanks in Advance |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Please re-word your question.
What you are asking is not clear. |
|
| Back to top |
|
|
sakthivel_t100
Warnings : 1
New User
Joined: 03 Aug 2007
Posts: 10
Location: chennai
|
|
|
|
Hi All,
How do you tune a query dynamically?
For Example :
Suppose I am running a certain application my application was hange due to some issue without aborting my application I have to tune the query? is it possible.
Thanks in Advance |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| I don't think so, tuning is usually a result of trial and error, making chioces and testing them..... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
You might diagnose performance problems dynamically, but it is less likely that you can tune them dynamically.
To tune a query, you typically modify the SQL, the data structure, or the code that invokes the SQL (or all of these). None of that is dynamic. |
|
| Back to top |
|
|
|
|
