Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?
- 1 Answers
- 3233 Views
- I also Faced
- E-Mail Answers
Answer / guest
Presence of statistics in the data dictionary for atleast
one of the tables accessed by the SQL statements is
necessary for the OPTIMIZER to use COST-based approach.
Otherwise OPTIMIZER chooses RULE-based approach.
| Is This Answer Correct ? | 0 Yes | 0 No |
Briefly explain what is literal? Give an example where it can be used?
Is a rollback possible to any savepoint?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
What are the oracle differences between nvl and coalesce
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
What is Data Block ?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
What is system global area (sga) in oracle?
What is logical backup in oracle?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
what is the difference between UNION AND UNIONALL
select * from emp what happened internally when we write this query in the sql prompt?
Oracle General 
