View previous topic :: View next topic
|
Author |
Message |
abdulrafi
Active User
Joined: 14 Sep 2009 Posts: 184 Location: Coimbatore
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
yes, change line three (3) of your SQL to: -execute faster |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|