IBM Mainframe Forum

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..

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

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.