Abstract
One major factor to obtaining and sustaining good performance within an IBM Informix database is having the appropriate statistics available. This article provides another method and explores the “output to pipe” utility within SQL.
There are several ways that statistics can be maintained, the most common, apart from home grown, are:
- AUS – Auto Update Statistics, driven by the dbscheduler and configured most easily through OAT
- Art Kagel’s dostats package – widely used in the IBM Informix Community and comprehensive
What is focused on here is having a simple method to generate and run efficient update statistics commands providing the recommended set of required statistics without getting into setting up AUS or compilation of dostats – i.e. a simple way to ensure your database has the relevant statistics generated using a single command; ideal for test environments or small production environments. This also makes use of the IBM Informix SQL statement “output to pipe” which is used to pass output to another program, in this example, “awk”.
[Read More…]
