How do you improve DB2 SQL performance?

Questions by Anilsodadasi   answers by Anilsodadasi

Showing Answers 1 - 2 of 2 Answers

kalone

  • Feb 1st, 2010
 

To improve the performance following are some of the tips :

1. Always use FOR UPDATE OF when updating with a cursor.
2. Use WHERE CURRENT OF to delete a single row.
3. Check the SQLCODE after each SQL statemnt.
4. Avoid using WHENEVER.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions