Db2 Sql 75+ Tuning Tips for Developers
DB2 SQL developers now have a handy reference guide with tuning tips to improve performance in queries, programs and applications. Poorly coded programs or improperly coded SQL statements are often the culprit causing poor performance. Many developers working with an IBM DB2 relational database will benefit from this guide, entitled 'DB2 SQL 75+ Tuning Tips For Developers'. The book's focus is to increase developers' knowledge in the ways of performance and tuning in an IBM DB2 relational database environment. In an organized and easy-to-understand format, the guide provides development and SQL tips that will help developers improve performance problems. By modifying application and SQL code, understanding Runstat options, or adding and altering indexes, there are many things that developers can do to resolve performance issues. This book provides development tips and suggestions, along with many SQL coding examples, all with the purpose of gaining better performance.
FORWARD DEDICATION DISCLAIMER
DB2 SQL HINTS
SQL PROGRAM WALKTHROUGHS
TEN STEPS TO TUNING A QUERY
abend access path application array BONUS clause clustering index Cobol program column contains continued correlated subquery correlation IDs created Current of Cursor cursor processing D.DEPTNAME D.MGRNO database datatype DB2 SQL DBAs Delete Where Current DEPTNO Dynamic Scrollable Cursors E.LASTNAME FROM EMPLOYEE E.SALARY E.WORKDEPT efficient eliminate EMP_CSR EMPNO ensure example execute existence checking filter factor frequency value statistics Getpages hard coded HIREDATE host variables IBM DB2 index files index processing index scan Inner join LASTNAME loaded locks logic Multi Row Nested Loop Join non-indexable null indicator number of rows OLTP order of tables Outer Joins performance issues query reoptimize REORG result set retrieve rewrite ROWID ROWSET Runstats runtime SALARY Scalar functions SELECT D.DEPTNO SELECT E.EMPNO Select statement sort specific SQL code SQL statement Stage 2 predicate starting Driver Stored Procedures TABLE1 tablespace file tablespace scan take advantage tuning tip typically update or delete WORKDEPT Z/OS