Advanced Data Tools Logo
spacer
Consulting Training Tech Info Successes User Groups Our Company spacer
   
IBM Business Partner
 

We build FAST Informix Databases!

 

Next Webcast!

Informix Webcasts by Thomas Beebe, Art Kagel, Lester Knutsen and Mike Walker - more for 2019 coming soon...

We are pleased to share our Webcast series for Informix DBAs - "Informix Best Practices". We will discuss configuration, disk layout, backups, performance tuning, and high availability disaster recovery implementation. Our Informix Best Practices are based on over 30 years of experience managing and tuning database systems. The webcast will be presented by Lester Knutsen, Principal Database Consultant, Art Kagel, Tom Beebe, and Mike Walker, IBM Informix Champions from Advanced DataTools.

Stay Informed! Sign up for our Mailing List

 

Lester Knutsen

Database Indexes - Best Practices for Informix DBAs by Lester Knutsen - Thursday, August 29, 2019, at 2:00 pm EDT Register here

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.

  • What is an index?
  • How do you improve performance with an index?
  • What is the performance cost of an index?
  • How do you speed up creating indexes?
  • How do locks affect indexes?
  • How to monitor an index to see if it is needed or used?
  • When is an index unnecessary?
  • When is an index needed or required?
  • What is a clustered index?
  • How do you maintain indexes for peak efficiency?
  • What is a functional index?

 

Lester Knutsen

Informix SQL Explain - Using the SQL Optimizer Query Explain Plan by Lester Knutsen - Thursday, October 31, 2019 at 2:00pm EDT Register here

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.

 

Lester Knutsen

Informix Update Statistics - Best Practices for Informix DBAs by Lester Knutsen - Thursday, November 21, 2019 at 2:00pm EST Register here

Informix has Automated Update Statistics built into the server. Update Statistics collects metrics to enable the server to run your SQL faster. How do you monitor what tables and indexes need to have the statistics updated and manage Automated Update Statistics (AUS)?

Click here for our past Webcast Replays focusing on Informix Performance Tuning and using Informix and the Internet of Things (IoT)

 

   
spacer
spacer