Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 4313 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the best way to do multi-row insert in oracle?
How do you find current date and time in oracle?
What are the predefined tablespaces in a database?
What is a cursor and what are the steps need to be taken?
What is a snapshot in oracle database?
What are the different windows events activated at runtime ?
Explain mutating triggers.
Why cursor variables are easier to use than cursors?
What to do if the binary spfile is wrong for the default instance?
Is truncate autocommit in oracle?
Give the different types of rollback segments.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How do you bind variables in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
