© Copyright, 2002 Howard F.
Arner, Jr. All Rights Reserved. Unauthorized duplication prohibited.
How the
optimizer uses logicals
•Optimizer looks at statement to determine
columns accessed, conditions for retrieval, ordering and joins
•The more tables
accessed in a statement, the more time this takes
•The more logical files
over each physical file adds time to this operation