Les02-优化器.pptVIP

Introduction to the Optimizer Objectives After completing this lesson, you should be able to do the following: Describe the functions of the Oracle9i cost-based optimizer (CBO) Identify the factors that the CBO considers Set the optimizer approach at the instance and session level Use dynamic sampling Functions of the Oracle Optimizer Evaluates expressions and conditions Uses object and system statistics Decides how to access the data Decides how to join tables Decides which path is most efficient Uses dynamic sampling Steps in Optimizer Operations Evaluation of expressions and conditions Stat