OPTIMIZERMODE initialization parameter to CHOOSE or COST - Oracle Distributed Database concepts

Q.  To enable cost-based optimization set the OPTIMIZER_MODE initialization parameter to CHOOSE or COST, you can set this parameter by using __________.
- Published on 12 Aug 15

a. Modifying the OPTIMIZER_MODE parameter in the initialization parameter file
b. Setting it at session level by issuing an ALTER SESSION statement
c. Both A & B
d. None of the above

ANSWER: Both A & B

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - After you have set up your system to use cost-based optimization to improve the performance of distributed queries, the operation is transparent to the user.

    - In other words, the optimization occurs automatically when the query is issued.

    - Setting Up the Environment
    - To enable cost-based optimization, set the OPTIMIZER_MODE initialization parameter to CHOOSE or COST.

    - You can set this parameter by:
    1. Modifying the OPTIMIZER_MODE parameter in the initialization parameter file

    2. Setting it at session level by issuing an ALTER SESSION statement

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲