Les07-干预优化器.pptVIP

Influencing the Optimizer Objectives After completing this lesson, you should be able to do the following: Influence the optimizer behavior at the following levels: Instance and session level Statement level Specify access-path hints Specify hints on and in views Setting the Optimizer Mode At the instance level, set the following parameter: For a session, use the following SQL command: Full Notes Page Some Additional Parameters OPTIMIZER_FEATURES_ENABLE Set to current release to enable the latest optimizer features Defaults to current release of database OPTIMIZER_INDEX_COST_ADJ Optimizer Hi