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
- 3871 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 rename an existing table?
Explain a segment?
How to install oracle database 10g xe?
What happens if recursive calls get out of control?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to create a new tablespace in oracle?
How to connect to a remote server?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to turn on or off recycle bin for the session?
what is insert all statement in sql
How to login to the server without an instance?
How to convert numbers to characters in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How to assign a tablespace to a users in oracle?
How different is ms access and oracle?
