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 |
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
How to export several tables together?
What is a table index in oracle?
Is postgres faster than oracle?
what is the scripts in data base?
Can we create more than one index on particular column?
does the query needs a hint to access a materialized view?
Use of an integrity constraint is better to validate data. Explain
What is Java Pool in Oracle?
what are stored procedures?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions