Interested to Buy Any Domain ? << Click Here >> for more details...
Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?
- 1 Answers
- 3977 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 |
how to genarate random numbers in oracle for particular row?
What is the difference between a hot backup and a cold backup in oracle?
Difference between cartesian join and cross join?
What is STATSPACK tool?
difference between imlicit cursor and explicit cursor ?
How to connect asp pages to oracle servers?
What is the difference between I and G in Oracle?
How to create a new oracle data file?
How to test null values?
Can sub procedure/function be called recursively?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
what is Single Byte Overhead...?
Oracle General 
