KalyaniCh New User Joined: 05 Jan 2009 Posts: 1 Location: Hyderabad
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
Gnanas N Active Member Joined: 06 Sep 2007 Posts: 788 Location: Chennai, India
There are many factors for performance.
You have to discuss with your DBA.
dick scherrer Site Director Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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.
dbzTHEdinosauer Global Moderator Joined: 20 Oct 2006 Posts: 6970 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.
All times are GMT + 6 Hours