Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ?
- 1 Answers
- 4180 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
This value causes the optimizer to choose the rule_based
approach for all SQL statements issued to the instance
regardless of the presence of statistics.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to declare a local variable?
How do I connect to oracle database?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
what is the difference between restoring and recovering?
How to drop an existing table in oracle?
Explain integrity constraints?
How to check the server version in oracle?
How translate command is different from replace?
What is oracle datasource?
How to use like conditions in oracle?
What is SQL Tuning Advisor in Oracle?
Is the After report trigger fired if the report execution fails ?
What are ddl statements in oracle?
How to start a specific oracle instance?
How different is ms access and oracle?
