Conference Schedule

   

Presentation Information

Presentation Title:   Experience with Auto Update Statistics
Primary Speaker:   Benjamin Thompson
Bio:   Benjamin is the Principal DBA for Sky Betting and Gaming, an online bookmaker and gaming company, having worked previously for TSYS, a US credit card processor, and Monitor Computer Systems, a provider of alarm monitoring software to the Europe, the Middle East and US. In all his roles he has been primarily working with Informix. Along the way he also picked up a few skills in other RDBMSs but Informix remains my favorite to work with. Benjamin's main regular contribution to the Informix community is to write blog posts covering topics of concern to a production Informix DBA as well as occasionally contributing to the IIUG technical discussion groups. You can find his writings under Informed Mix. Locally in Yorkshire, he is a committee member of YoDB, a local database user group, which doesn't focus on Informix but has featured some talks on IoT and Informix on single board computers of interest to the wider community. Benjamin's primary work responsibility is oversight of his company's production databases which have 24/7 uptime requirements and high transaction throughput levels. This tends to make the company well-known to EMEA support.
Presentation
Abstract:
  
When to update statistics and distributions, how often
and at what resolution can be tricky questions.
Application
vendors rarely specify any requirements in this area
except "good performance". If you have a small database,
simply updating statistics for everything frequently may
be a strategy but it's not one that scales.

If you've ever wondered why you need statistics and
distributions, when it's important that they're really
current
and when it's not, this talk is for you.

I'll be covering all aspects of IBM's Auto Update
Statistics (AUS) feature and show how tuneable and
customizable it is, all from the command line. Along the
way I'll cover a few specific scenarios where AUS can
cater to specific requirements. I'll also show how you
monitor it to make sure it's doing what you expect.
Co-Speakers
or Panelists:
  
None