What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ?
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 do we get field details of a table?
primary key is foreign key for the same table?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Explain the use of file option in exp command.
How to divide query output into groups in oracle?
Explain the dml?
How do we create privileges in oracle?
In Oracle 10g, "g" Stands for what?
What is a Synonym ?
is database gud carrier option??
What are the restrictions on external table columns?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3