Performance Tuning SQL queries
Posted: Tue Jul 22, 2008 11:24 am
Please suggest some tips for Performance Tuning the SQL queries in DB2
Mainframe Technical Support Forums
https://www.ibmmainframeforum.com/
Other than the very obvious (i.e. use a key to directly access data rather than a full table scan), production tuning involves identifying where time is being spent - then determining a better way to get the same result. Rather than waiting for productoin problems, this should be done as early as possible during development because often the "fix" requires some amount of re-design.Please suggest some tips for Performance Tuning the SQL queries in DB2