Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4705 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 |
How to Remove the 3rd highest salary person record from table?
Explain the difference between a procedure and a function? What do you understand by those terms?
How many types of table in Oracle?
How to return top 5 rows in oracle?
How to create an oracle database?
What are the factors causing the reparsing of SQL statements in SGA?
What happens if the update subquery returns multiple rows?
Can select statements be used on views in oracle?
Does oracle partitioning improve performance?
Explain about integrity constraint?
What happens in oracle commit?
How to write a query with a left outer join in oracle?
Oracle General 
