Articles & Content

Archives

Informix SQL Performance Tuning - Advanced Topics (L14)

Topic: 2005 NA

Subtopic: Cross Platform DB2 for z/OS & LUW



DATE: 2005-5-25 (03:30 PM - 04:40 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. A lot of effort is put into tuning the hardware and the database engine, however, properly tuned SQL returns the greatest increase in performance. This presentation covers areas of SQL tuning that will improve the performance of your application.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

SQL Optimization tips and techniques

Overview of indexes and their use in queries

Data Access Methods

Join Methods

Correlated Sub-Queries



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.