||Experience with Auto Update Statistics|
||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
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
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.|
|When to update statistics and distributions, how often
and at what resolution can be tricky questions.
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
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.