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.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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. . .