db2 Query performance



db2 Query performance

Postby Naagju » Thu Apr 28, 2011 12:10 am

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..
Naagju
 
Posts: 16
Joined: Tue Feb 22, 2011 10:45 pm
Has thanked: 0 time
Been thanked: 0 time

Re: db2 Query performance

 

Re: db2 Query performance

Postby Nik22Dec » Thu Dec 29, 2011 3:11 pm

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
Thanks,
Nik
User avatar
Nik22Dec
 
Posts: 68
Joined: Mon Dec 26, 2011 6:38 pm
Has thanked: 2 times
Been thanked: 0 time

Re: db2 Query performance

Postby dick scherrer » Fri Jan 06, 2012 9:39 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to Interview Questions

 


  • Related topics
    Replies
    Views
    Last post