What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
Answers were Sorted based on User's Feedback
Answer / guest
The OPTIMIZER_MODE initialization parameter Statistics in the
Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER
SESSION command hints in the statement.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nishi
This value causes the optimizer to the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best throughput.
Is This Answer Correct ? | 0 Yes | 0 No |
Explain the use of full option in exp command.
What is execute immediate in oracle?
What is a cursor and what are the steps need to be taken?
Can multiple cursors being opened at the same time?
What is a lookup table in oracle?
What is sharded cluster?
What are the various types of snapshots ?
what is dynamic SGA and static SGA
How to get last row id?
What is the difference between Delete, Truncate and Drop in Oracle?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
What is Undo Management Advisor in Oracle?