Articles & Content


Informix SQL Performance Tuning - An Introduction (L03)

Topic: 2005 NA

Subtopic: DB2 for LUW

DATE: 2005-05-23 (02:00 PM - 03:10 PM)
SPEAKERS: Mike Walker (UCI Consulting, Inc)

Performance is a key ingredient to the successful implementation of any application. One of the key pieces to performance is tuning the SQL in your application. This presentation covers introductory concepts of SQL performance tuning including identifying slow running queries, reading set explain output, indexes and tuning tips and techniques.

EXP. LEVEL: Beginner,Intermediate,Advanced


Identifying Slow Queries

Set Explain Explained

Introduction to Indexes

SQL Optimization Tips and Techniques

Questions and Answers

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.