Articles & Content

Archives

Automated Index Optimisation - Is It Even Possible? (F03)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS



DATE: 2010-11-8 (16:00 - 17:00)
SPEAKERS: Phil Grainger (Cogito/GdbS)

One of the key performance tuning "knobs" for a DB2 application is the provision of adequate indexes - or better still, provision of exactly the RIGHT indexes.The snag is, as DB2 evolves and as the optimiser gets smarter, that set of "right" indexes may change over time.In addition, workload and usage changes of the application itself may also change what is the right indexing strategy.Of course, it has always been possible to manually determine which indexes are needed (and perhaps which ones are now not helping as much as they should) this approach has the twin disadvantages of requiring highly skilled people to do the analysis and taking an excessive amount of time to do correctly.This is why there has been a search amongst software vendors for the "holy grail" of an automated index determination solution.But is this even possible, and if it is, does the resulting answer actually "do the job" or does it just take too long to come to a determination.So is automatic index evaluation even possible?This presentation looks at the possibilities

EXP. LEVEL: Intermediate

OBJECTIVES:

Why is index design even necessary

Why automate it

Pitfalls of automation

Some automation suggestions

Summary



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.