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 |
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
Explain drop constraint oracle?
Why does for update in oracle 8 cause an ora-01002 error?
How to Remove the 3rd highest salary person record from table?
What is meant by raw datatype?
Use of an integrity constraint is better to validate data. Explain
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Is truncate autocommit in oracle?
what is main def between plsql/table and array?
What is background process in Oracle?
How can we force the database to use the user specified rollback segment?
What happens in oracle commit?