How does the Informix SQL Optimizer choose which index or table or access method to use when running your SQL? This presentation will focus on how to view and understand the SQL Explain plan to see how your SQL is executed. The SQL Explain plan will provide times for each step in your process.

This presentation will focus on Best Practices for Informix database indexes. Every table should have at least one index, and managing indexes is an integral part of a DBA's task and time. Indexing is one method to optimize the performance of a database by reducing the number of disk reads when a query is executed. An index is a structure which is used to locate and access a row in a database table quickly. Indexes are used to enforce uniqueness, primary, and foreign keys and constraints. Indexes can also be a source of problems in a database and may slow performance down when misused.

IBM just announced the exciting new Informix 14 version in March. Advanced DataTools taught our first course for Informix DBAs on release 14 in April. We have been part of the beta programs and would like to share our findings including how to use the new installer, how to upgrade a database, and an introduction to the new Informix HQ server management.

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

This is a continuation of an earlier Webcast on Informix Configuration, ONCONFIG, CPUs, and Memory.

This is a replay from our webcast reviewing the results of our Fastest Informix DBA Contest II, done online in the fall of 2009, discussing how the winners did it. Congratulations to Tatiana Saltykova, new 1st place finisher in the Fastest Informix DBA contest! The challenge was to take a batch billing SQL job that took over 40 hours to run and optimize it and the Informix database configuration.

Informix 4GL Programming Tips

First published in the Washington Area Informix User Group Newsletter Volume 4, No. 3 – July 1994 1. Only select columns that you really need When you select data, it goes from disk to memory.  Ten un-needed bytes of data from 10,00 rows translates into reading 100,000 bytes unnecessarily.  Avoid “SELECT *” statements and only […]