Articles & Content

Archives

Informix SQL Performance Tuning Tips (L06)

Topic: 2007 NA

Subtopic: Informix



DATE: 2007-5-8 (10:40 AM - 11:40 AM)
SPEAKERS: Jeffrey Filippi (Integrated Data Consulting, LLC)

Taking a different approach to tuning of SQL to be able identify and resolve issues quicker and more effectively.- Know your application in tuning SQL.- Tuning for OLTP vs DSS Environments.- Reading of sqexplain output and tuning.- Use of Informix tools for analyzing SQL.- Understanding options used to tune SQL

EXP. LEVEL: Beginner,Advanced

OBJECTIVES:

How to review not just the SQL statement, but other aspects of what the issue could be

How to read SQL, explain output and things to look for in the explain output that can help determine the best solution

How to utilize new features of Informix that can improve SQL performance

Knowing how to tune in an OLTP vs DSS environment

Learn different techniques in the tuning of SQL



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.