Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?
- 1 Answers
- 3240 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 |
What is Parallel Server ?
Explain the use of online redo log files in oracle.
How to connect to a local oracle 10g xe server?
Explain the characteristics of oracle dba?
How do we get field detail of a table?
What is the difference between a vector and an Array? (Java)
What does ROLLBACK do ?
How to define and use table alias names in oracle?
what is the exact definition for pointer?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Please explain oracle left join with an example?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Oracle General 
