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
- 4132 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to create a testing table in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What are the ways tablespaces can be managed and how do they differ?
Calculate difference between 2 date / times in oracle sql?
what is index?
What is the relationship among database, tablespace and data file?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
How do you rate yourself in oracle and sql server ?
What are the execution control statements?
What is trigger associated with the timer ?
can u plz provide me oca sql dumps please i need them
Explain the use of indexes option in imp command.
Oracle General 
