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 do you rate yourself in oracle and sql server ?
What is SAVE POINT ?
how to get the no employee in each department including the dept which has 0 employee
How can you merge two tables in oracle?
Give the various rollback segment states.
What is a Database instance ? Explain?
Why do we need oracle client?
What do you mean by merge in oracle?
Which are the five query types available in oracle?
Can we write insert statement in function in oracle?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
How to use an explicit cursor without open statements?