Conference Schedule – Subject to Change

   

Presentation Information

Presentation Title:   Informix Query Performance Tuning Basics
Primary Speaker:   Mike Walker
Bio:   Mike has been using Informix for 20 years as both a developer and DBA. Mike has developed and supported large data warehouses and has experience with the Informix Warehouse Accelerator. Mike heads up the Remote DBA service offered by Advanced DataTools, monitoring and providing support to Informix customers.
Presentation
Abstract:
  
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
- Finding busy tables

The session will NOT include administration tasks of
onconfig tuning, disk/table layouts, etc.
Co-Speakers
or Panelists:
  
None