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
- 4038 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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain the use of log option in exp command.
What happens to the data files if a tablespace is dropped?
How to generate query output in html format?
What is a server parameter file in oracle?
What is bulk load in oracle?
What is system global area (sga) in oracle?
What are the differences between number and binary_float in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to enter a new row into a table interactively?
How to create an oracle database?
What is the difference between I and G in Oracle?
How to create tables for odbc connection testing?
What are the advantages of oracle?
What happens if you lost a data file?
