Articles & Content

Archives

Understanding the Query Optimizers Explain File (K06)

Topic: 2005 NA

Subtopic: Informix



DATE: 2005-05-24 (10:00 AM - 11:10 AM)
SPEAKERS: John F. Miller III (IBM)

The set explain file is used by DBA to examine the plan the optimizer is using for queries. This talk will examine the different parts of the set explain file and how to interupt them.

EXP. LEVEL: Intermediate

OBJECTIVES:

Query Optimizers Explain File

The different parts of the explain file

The different optimizer operators

Interupting the information in the explain file

Correcting problems



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.