Articles & Content
Topic: 2010 EMEA
Subtopic: DB2 for z/OS
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
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.