Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?
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 unlock the sample user account in oracle?
What is where clause in oracle?
What is an Extent ?
What are the differences between number and binary_float in oracle?
What is difference between SUBSTR and INSTR?
What are the different types of databases?
Explain the types of exception?
Explain the use of analyse option in exp command.
What is ADDM Advisor in Oracle?
What is an index associated with a constraint?
Explain self joins in oracle?
What is an oracle transaction?