Articles & Content

Archives

Lessons Learned from SQL Performance Reviews (F14)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2010



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

OBJECTIVES:

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.