Data Access Question:

Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?

Oracle Data Access Interview Question
Oracle Data Access Interview Question

Answer:

CHOOSE,
ALL_ROWS,
FIRST_ROWS and
RULE.


Previous QuestionNext Question
What is COST-based approach to optimization?Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach?