Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4649 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to create a table in a specific tablespace?
Is the After report trigger fired if the report execution fails ?
How do I find my oracle client driver version?
What is the difference between primary key and unique key and foreign key in oracle?
What is the difference between post-database commit and post-form commit?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is SQL Tuning Advisor in Oracle?
How to start a specific oracle instance?
Explain what does a control file contain?
In the oracle version 9.3.0.5.0, what does each number shows?
Explain the truncate in oracle?
How do you bind variables in oracle?
Difference between varchar and varchar2 data types?
What is sharded cluster?
Will you be able to store pictures in the database?
