What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?
- 1 Answers
- 3167 Views
- I also Faced
- E-Mail Answers
Answer / guest
This value causes the optimizer to choose the rule-based
approach for all SQL statements in a session regardless of
the presence of statistics
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the syntax of SELECT command?
what is the use of rank function?
Explain the use of analyse option in exp command.
Can you have more than one content canvas view attached with a window ?
What privilege is needed for a user to insert rows to tables in another schema?
what is foreign key?
How to save query output to a local file?
What are the advantages of oracle 12c?
How to set a transaction to be read only in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
what is difference between table and view? where to use views? thanks in advance!
How to create an oracle database manually?
Oracle General 
