Page 1 of 1

db2 Query performance

PostPosted: Thu Apr 28, 2011 12:10 am
by Naagju
Hi...

i got encountered with a question on Db2
that is..
i have a SQL Query...which taking much time to run..
How can i improve performance f that Query..with out modifying query.

Advance Thanks for u r replay.


Regards!!
Naagju..

Re: db2 Query performance

PostPosted: Thu Dec 29, 2011 3:11 pm
by Nik22Dec
Hi,

You can try running RunStats & Reorg on the DB2 Table which you are querying. Housekeeping DB2 Table/Tables could also be an option.

Thanks & Regards,
Nik

Re: db2 Query performance

PostPosted: Fri Jan 06, 2012 9:39 am
by dick scherrer
Hello,

How can i improve performance f that Query..with out modifying query.
You probably cannot. . .

One way would be to delete or archive in some other table most of the data in the problem table.

If you do runstats or explain or use some other analysis tool, the outcome will most likely be that the table definition, the sql code, or both will need to be changed.