What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Answer / guest
This value causes the optimizer to use 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 response time.
Is This Answer Correct ? | 0 Yes | 0 No |
How to check your oracle database 10g xe installation?
what is the difference between table and veiw?
What is the parameter mode that can be passed to a procedure?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
What is a table in oracle?
How can we find the size of a database?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
How to select some rows from a table in oracle?
Describe the types of sub query?
How to do a full database export?
What is Database Buffers ?