| 2. |
Which actions can request a different optimizer goal for a session or an individual query without changing the system-wide default? (Choose all that apply.)
Please select all the correct answers.
|
| |
A.
|
Run ALTER SESSION SET OPTIMIZER_MODE = FIRST_ROWS_10. |
| |
B.
|
Run the query from SQL*Plus without changing settings or adding hints. |
| |
C.
|
Run ALTER SESSION SET OPTIMIZER_GOAL = FIRST_ROWS_10. |
| |
D.
|
Place an applicable goal hint, such as /*+ ALL_ROWS */, immediately after the SELECT keyword. |