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
- 3967 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What happens if the update subquery returns multiple rows?
What are the different pseudo commands? Explain in general?
What do you mean by a deadlock?
What is recovery manager(rman) backup in Oracle?
What do you understand by a database object? Can you list a few of them?
defination of bitmap index
Can we protect our pl/sql source code?
What are the major difference between truncate and delete?
What are the arithmetic operations?
What is blob datatype?
candidate key is subset of super key but not vice-verse explain
How to drop a tablespace?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Why packages are used in oracle?
