Cogito DB2 Tech Talk - Automated Index Optimisation - Is It Even Possible?

Phil Grainger

Cogito DB2 Tech Talk - Automated Index Optimisation - Is It Even Possible?
Please join Cogito and Phil Grainger for the first DB2 Tech Talk of 2011 on
Thursday January 20th at 2.00pm GMT

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, the 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

Registration is open at

Phil's talk is followed by a short (15 minute) live demo of the EZ-Index
Analyzer product from Cogito.

Note: Cogito reserves the right to deny attendance at its sole discretion
and it is preferred that attendees register using a company email address
and not a generic email address such as gmail, yahoo, hotmail etc.

Phil Grainger

Cogito Ltd.

[login to unmask email]

+44 (0) 1298 872 148

+44 (0) 7505 266 768

Attend IDUG 2011 - the premiere events for DB2 professionals.

IDUG North America, 2-6 May, Anaheim California

IDUG EMEA, 14-18 November, Prague Czech Republic

* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!

If you need to change settings, is the home of IDUG's Listserv