InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Effect Of Setting The Value "all_rows" For Optimizer_goal Parameter Of The Alter Session Command ? What Are The Factors That Affect Optimizer In Choosing An Optimization Approach ? |
|
Answer» The OPTIMIZER_MODE initialization PARAMETER STATISTICS in the DATA Dictionary. The OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement. The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary. The OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement. |
|