Articles & Content
Topic: 2010 NA
Subtopic: 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
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.