What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 3654 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
How to resolve name conflicts between variables and columns?
What is meant by recursive hints in oracle?
How to use select statement to count the number of rows in oracle?
Write a trigger example in oracle?
How does Oracle guarantee data integrity of data changes?
How to install oracle database 10g xe?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is transport network substrate (tns) in oracle?
Explain index?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is a connect identifier?
Name the various constraints used in oracle?
What are the different editions of oracle?
How to drop an index in oracle?
