Articles & Content

Archives

Informix SQL Performance Tuning Tips (L06)

Topic: 2006 NA

Subtopic: Informix



DATE: 2006-05-09 (01:00 PM - 02:10 PM)
SPEAKERS: Jeffrey Filippi (Integrated Data Consulting, LLC)

Tuning SQL can be a time consuming and difficult process. Having the right knowledge to effectively tune SQL statements, can have a tremendous effect on improving your systems performance.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Knowing how to read sqexplain output

Understanding options to use in tuning SQL

Understanding the application in tuning SQL

Use of Informix tools in analyzing and tuning SQL

Tuning for OLTP vs DSS



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.