Articles & Content

Archives

Let's Investigate the Predicate (B05)

Topic: 2005 NA

Subtopic: DB2 for z/OS



DATE: 2005-05-24 (08:30 AM - 09:40 AM)
SPEAKERS: Frank Ingrassia (Innovative Management Solutions Inc.)

Recent releases have significantly changed the use, power and evaluation of SQL predicates. Here, we'll focus on predicate characteristics, filter factors, and other properties that shape the optimizer's use, or discarding, of predicates. PTC and the influence of catalog statistics are among the many topics we'll explore. Examples will show how the V8 optimizer views predicates and evaluates potential use in access paths.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

classification, properties and characteristics

stage 1, indexable, screenable, boolean term?

filter factor computations and formulas

influence of column and distribution statistics

let's play with predicates in the real world



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.