IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

optimization of DB2 queries


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
abdulrafi

Active User


Joined: 14 Sep 2009
Posts: 184
Location: Coimbatore

PostPosted: Fri Feb 04, 2011 7:33 pm
Reply with quote

i have coded a SELECT query in db2 program which takes more time when considering CPU time. its just a normal select query on a DB2 table. I need to reduce it as it would take more time in production too. Could anybody please suggest anyway on how can i reduce the time when executing such a SELECT DB2 query.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Feb 04, 2011 7:43 pm
Reply with quote

yes, change line three (3) of your SQL to: -execute faster
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Feb 04, 2011 9:01 pm
Reply with quote

Hello,

Let's see. . .

You have not posted the query. You have not posted any information about the table(s) such as how many rows, the keys, etc. What is the difference (to you) between a normal query and a "not normal" query. What does an Explain for this query show?

How might we help if you provide nothing for us to use to help you. . .

Until you provide something useful, you'll need to use the suggestion frmo DBZ. . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Index related queries DB2 5
No new posts Need help with below queries DB2 3
No new posts SQL Query optimization. DB2 12
No new posts Running queries against OLTP Database DB2 3
No new posts Selective execution of a queries DB2 9
Search our Forums:

Back to Top