Articles & Content

Archives

Lessons Learned from SQL Performance Reviews (F14)

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

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



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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.