Articles & Content
Topic: 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
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.