View previous topic :: View next topic
|
Author |
Message |
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi,
I have consolidated an SQL report, it has INDB2_TIME, INDB2_CPU & planname.
INDB2_TIME - Time spent within DB2 for this statement
INDB2_CPU - CPU time spent processing this statement
I was told to find which PLAN takes a lot of time - That's done.
Now i was told to find some methods for improving ?
What i want to know is, where to start & what to see ?
Open to IDEAS & Suggestion,
Sushanth |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Explain the PLAN. Find out the pain point queries. Check if there is a better way of writing an equivaent query. Check if the new equivalent query is actually better than the original. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Yes i also thought about that Bharath. EXPLAIN.
Quote: |
Check if there is a better way of writing an equivalent query. |
What if the queries are done dynamically using PREPARE STATMENT like that. Right now iam looking at the WAREHOUSING sub-system & its PLANs.
Suggesting MQT's are on my list.
What are the other things i need to look in WAREHOUSING kind of scenarios.
Sushanth |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Quote: |
What if the queries are done dynamically using PREPARE STATMENT like that. |
Suggest to change it to static SQL. Dynamic SQLs are major pain points. |
|
Back to top |
|
|
|