This session will cover some of the basics of Informix Tuning, with a focus on monitoring and tuning of queries. Some of the areas that will be covered include: Identifying long running queries, Explain plans, Optimizer directives, Monitoring the buffer pool usage, Checking statistics, and Finding busy tables

Art presents UPDATE STATISTICS in depth, dostats, and his other free utilities for monitoring and tuning an Informix database in his utils2_ak package. Topics covered will include: *Table Level statistics and data distributions *Fragment Level statistics and data distributions *Update statistics for procedure/function *Providing data distributions for User Defined Types *Dostats and the art of balancing distribution quality with runtime performance *Other useful utilities in the utils2_ak package