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


Please Help Members By Posting Answers For Below Questions

How to list all tables in your schema?

799


What is define in oracle?

813


Explain about integrity constraint?

884


Describe an oracle table?

801


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

756


How do I manually uninstall oracle client?

771


How to create a single index for multiple columns?

773


How to create a new oracle data file?

777


What is an oracle tablespace?

791


What are set operators?

837


How to use fetch statement in a loop?

785


How can we find out the duplicate values in an oracle table?

830


What are the restrictions in a oracle read only transaction?

780


Which environment variables are absolutely critical in order to run the OUI?

1910


Differentiate between function and procedure in oracle.

787