5. 数据库优化.ppt

* * * * Setting the Optimizer Mode The optimizer mode can be set at the: Instance level by using the OPTIMIZER_MODE parameter Session level, by using the ALTER SESSION command Statement level, by using hints The DBA is responsible for setting the OPTIMIZER_MODE parameter at the instance level, because this requires restarting the instance. Typically, application developers can set the OPTIMIZER_MODE at the session level, as well as use hints in SQL statements. The OPTIMIZER_MODE Parameter The default value is Choose. This means that the optimizer uses the cost-based mode (All_rows) if statisti