©
Copyright, 2002 Howard F. Arner, Jr. All Rights Reserved. Unauthorized duplication prohibited.
Slide:
19
4/2/2002
Statement Optimization
•
For each logical file
–
Optimizer looks at index selectivity
–
Determines cost of access path usage
–
If cost < cost of previous path then
pop path to top of stack
–
See if time is expired or check next logical