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
What is an external table?
Can we use bind variables in oracle stored procedure?
What are the data types in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is not equal to in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Point out the difference between user tables and data dictionary?
What is blob data type in oracle?
What are the uses of Database Trigger ?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
what happened to the global index when I truncate the data in one of the partition?
What is oracle and what are its different editions?
Explain overloading. Can functions be overloaded?
How to load data through external tables?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.