Articles & Content

Archives

Optimizer Enhancements - Improve Query Performance (Part 1 of 2) (J12)

Topic: 2006 NA

Subtopic: DB2 for LUW



DATE: 2006-05-11 (08:30 AM - 09:40 AM)
SPEAKERS: Calisto Zuzarte (IBM Toronto Lab)

This session covers new features in the DB2 Optimizer and tips to help mprove query performance. We will look through some basics optimization oncepts and then drill down into some of the recent enhancements. Finally some tips onhelping the optimizer get better plans will be presented.

EXP. LEVEL: Intermediate

OBJECTIVES:

Exploiting New Statistics Features

Handling Complex Queries

New And Improved Query Rewrites

Improved Diagnostics

Optimizer Profiles And Guidelines



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.