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
- 3942 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 many types of database triggers exist?
What is a Tablespace?
What is flashback in Oracle?
What is clustered table in Oracle?
Explain constraining triggers.
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
How to use subqueries with the exists operator in oracle?
What is the difference between online and offline backups?
What is autonomous transaction?
What are the restrictions on external table columns?
What is a Database instance ? Explain?
How would you design a database for an e-commerce website?
Oracle General 
