Articles & Content

Archives

V8 SQL Performance and Optimization (G05)

Topic: DB2 for z/OS

Subtopic: 2005



DATE: 2005-10-24 (16:15 - 17:15)
SPEAKERS: Susan M Lawson (YL&A)

This presentation will cover aspects of Version 8 of DB2 on the z/OS platform relating to enhancements to SQL optimization and performance. This presentation will take a look at these features in detail to discuss usage and best implementation.

EXP. LEVEL: Intermediate

OBJECTIVES:

DPSI Query Issues

Optimization Enhancments

Distribution Statistics and Usage

Query Rewrite and MQTs

Star Joins and Volatile Tables



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.