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 to insert a new row into a table in oracle?
What is logical backup in oracle?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
What is difference between truncate and delete?
What is the difference between $oracle_base and $oracle_home?
State all possible different index configurations a table can possibly have?
how do u know the total no of rows in a table?
What is recycle bin in Oracle?
what is pragma?
can you write commit in triggers?
What is the exact use of Collections?
can a view be updated?