Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.