|
View previous topic :: View next topic
|
| Author |
Message |
KalyaniCh
New User
Joined: 05 Jan 2009
Posts: 1
Location: Hyderabad
|
|
|
|
Hi All
How do i resolve the performance issues with the Database. When ever i run some queries, they run for quite long time to fetch the results. I have seen the access path of the queries and made sure that , the tables are accessing indexes path only. I created additional indexes also when needed. I would like to know , how can I improve my Database performance, so that my queries runs faster.
DB2 Version is : 8.2 and 9.5
Thanks in Anticipation
Neha |
|
| Back to top |
|
 |
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
There are many factors for performance.
You have to discuss with your DBA. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I have seen the access path of the queries and made sure that , the tables are accessing indexes path only |
There is far more to tuning than simply naming an index in the "where". . .
With luck, simple code changes will provide improvement. If the problem is due to an overall design deficiency, the data structures may need to be changed.
Keep in mind that queries that run well with minimal data may completely grind to a halt with full-volume data.
As suggested, work with your dba. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
db2 vsn 9 has so many nifty new toys, visual explains, etc... that supports programmer developement efforts.... suggest you learn about your tool (db2 v9).
In order to give good help,
we need to know more than you do about your environment. |
|
| Back to top |
|
|
|
|
