[AD] DB2 Tech Talk - Automated Index Optimisation - Is It Even Possible?

Phil Grainger

[AD] DB2 Tech Talk - Automated Index Optimisation - Is It Even Possible?
Join Cogito and Phil Grainger for the last DB2 Tech Talk of 2010, on
Thursday December 2nd at 11am Eastern time (repeated on Thursday December
16th at 3pm Central European time)



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



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



To register, please visit http://www.cogitona.com/events/public-webinars
(though Mozilla Firefox users are better off heading to
https://www1.gotomeeting.com/register/667283097)



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

www.cogito.co.uk



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! *
_____________________________________________________________________
http://www.IDUG.org/mentor
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, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Phil Grainger

Re: [AD] DB2 Tech Talk - Automated Index Optimisation - Is It Even Possible?
(in response to Phil Grainger)
I've just noticed that the registration link from cogitona.com for this Thursdays webinar seems to be broken

If you would like to register, it should link to https://www1.gotomeeting.com/register/669126809

Apologies
Phil Grainger
Cogito Ltd.
[login to unmask email]
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk <blocked:: http://www.cogito.co.uk >

Attend IDUG 2011 - the premiere events for DB2 professionals.
IDUG North America < http://www.idug.org/na > , 2-6 May, Anaheim California
IDUG EMEA < http://www.idug.org/emea > , 14-18 November, Prague Czech Republic




From: Phil Grainger [mailto:[login to unmask email]
Sent: 30 November 2010 09:47
To: [login to unmask email]
Subject: [AD] DB2 Tech Talk - Automated Index Optimisation - Is It Even Possible?

Join Cogito and Phil Grainger for the last DB2 Tech Talk of 2010, on Thursday December 2nd at 11am Eastern time (repeated on Thursday December 16th at 3pm Central European time)

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

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

To register, please visit http://www.cogitona.com/events/public-webinars (though Mozilla Firefox users are better off heading to https://www1.gotomeeting.com/register/667283097)

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
www.cogito.co.uk

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 *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Phil Grainger

Re: [AD] DB2 Tech Talk - Automated Index Optimisation - Is It Even Possible?
(in response to Phil Grainger)
Apologies to all

As the registration link was broken for a couple of weeks before it was brought to our attention, we've decided to reschedule todays webinar to January 20th at the same time

If you had already registered you will have received a notification of the change of date so no need to register again

Apologies for any inconvenience

Phil Grainger
Cogito Ltd.
[login to unmask email]
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk <blocked:: http://www.cogito.co.uk >

Attend IDUG 2011 - the premiere events for DB2 professionals.
IDUG North America < http://www.idug.org/na > , 2-6 May, Anaheim California
IDUG EMEA < http://www.idug.org/emea > , 14-18 November, Prague Czech Republic


From: Phil Grainger
Sent: 13 December 2010 12:12
To: 'IDUG DB2-L'
Subject: RE: [AD] DB2 Tech Talk - Automated Index Optimisation - Is It Even Possible?

I've just noticed that the registration link from cogitona.com for this Thursdays webinar seems to be broken

If you would like to register, it should link to https://www1.gotomeeting.com/register/669126809

Apologies
Phil Grainger
Cogito Ltd.
[login to unmask email]
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk <blocked:: http://www.cogito.co.uk >

Attend IDUG 2011 - the premiere events for DB2 professionals.
IDUG North America < http://www.idug.org/na > , 2-6 May, Anaheim California
IDUG EMEA < http://www.idug.org/emea > , 14-18 November, Prague Czech Republic



From: Phil Grainger [mailto:[login to unmask email]
Sent: 30 November 2010 09:47
To: [login to unmask email]
Subject: [AD] DB2 Tech Talk - Automated Index Optimisation - Is It Even Possible?

Join Cogito and Phil Grainger for the last DB2 Tech Talk of 2010, on Thursday December 2nd at 11am Eastern time (repeated on Thursday December 16th at 3pm Central European time)

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

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

To register, please visit http://www.cogitona.com/events/public-webinars (though Mozilla Firefox users are better off heading to https://www1.gotomeeting.com/register/667283097)

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
www.cogito.co.uk

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 EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv