What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?
Answer Posted / 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 |
Post New Answer View All Answers
How to list all tables in your schema?
What is define in oracle?
Explain about integrity constraint?
Describe an oracle table?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How do I manually uninstall oracle client?
How to create a single index for multiple columns?
How to create a new oracle data file?
What is an oracle tablespace?
What are set operators?
How to use fetch statement in a loop?
How can we find out the duplicate values in an oracle table?
What are the restrictions in a oracle read only transaction?
Which environment variables are absolutely critical in order to run the OUI?
Differentiate between function and procedure in oracle.