Articles & Content
Topic: Cross Platform DB2 for z/OS & LUW
DATE: 2010-5-14 (09:45 AM - 10:45 AM)
SPEAKERS: Sheryl Larsen (Sheryl M. Larsen, Inc.)
This session divulges discoveries and solutions from various SQL performance review assignments. Come see if you have similar SQL performance issues and get the instructions on how to fix them. Issues discussed include non-optimal index design, access paths gone wild, Stage 2 predicates, misuse of SQL, excessive sorting, delayed filtering, lack of implementation of powerful new SQL feature.
EXP. LEVEL: Intermediate
Demonstrate how to detect and fix non-optimal index design
Demonstrate how to detect and fix access paths with delayed filtering or excessive sorting
Demonstrate how to detect and rewrite popular Stage 2 conditions
Demonstrate how to detect and rewrite misuse of SQL features
Demonstrate how to detect lack of implementation of powerful DB2 8, 9, & 10 features
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.