Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4569 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
The OPTIMIZER_MODE initialization parameter Statistics in the
Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER
SESSION command hints in the statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nishi
This value causes the optimizer to 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 throughput.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is recycle bin in Oracle?
What do you mean by group by clause?
how to find the n'th highest salary from emp ?
How to write an inner join with the where clause in oracle?
What is an oracle recycle bin?
Explain what are the type of synonyms?
select statement does not retrieve any records. what exception is raised?
What is the difference between translate and replace?
what is grid in Oracle 10g...
What is a dead lock in oracle?
What is an oracle and why it is used?
Can select statements be used on views in oracle?
Oracle General 
