Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?
- 1 Answers
- 3535 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
How to retrieve data from an explicit cursor?
How to best split csv strings in oracle 9i?
What is system global area (sga) in oracle?
How many types of tables supported by oracle?
How to assign a table row to a record variable?
How to create a new table in oracle?
Is java required for oracle client?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to create a stored procedure in oracle?
How would you go about verifying the network name that the local_listener is currently using?
How to handle a single quote in oracle sql?
Explain the difference between sap and oracle?
Can a formula column be obtained through a select statement ?
How to count groups returned with the group by clause in oracle?
What is a trigger oracle?
