Articles & Content

Archives

Ask not what the Optimizer can do for you - Ask what you can do for the Optimizer! (E03)

Topic: DB2 for z/OS

Subtopic: 2010



DATE: 2010-11-8 (16:00 - 17:00)
SPEAKERS: Suresh Sane (DST Systems Inc.)

This query used to run in 5 seconds and now takes an hour! How could the Optimizer do this to me? ? Sounds familiar? But are you sure the Optimizer is at fault? In this session, we will examine the challenges faced by cost-based optimization and identify steps to minimize, if not eliminate, such behavior. We will also cover various ways of influencing and stabilizing the optimal access path.IBM is doing their part " are you doing yours? We will transition from the Why doesn't IBM? ? complaint to the more positive What can I do TODAY? ? action plan.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Cost-based optimizer basics-Filter factors-Issues in access path creation

Stats, stats and even more stats-Basic stats-NUD-Correlation-Histogram

Case study " the irresistible index ?-Average v/s worst case-Index design

Access path management-Influencing-Stabilizing-Falling back

What does the future hold?-Directions-My wish-list



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.