What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Answer Posted / guest
This value causes the optimizer to the cost-based approach
for all SQL statements in the session regardless of the
presence of
statistics and to optimize with a goal of best throughput.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to list all indexes in your schema?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is recovery manager in Oracle?
What is a nested table and how is it different from a normal table?
What are the differences between number and binary_float in oracle?
What is index in Oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Why do we need integrity constraints in a database?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
Is primary key indexed by default in oracle?
How to assign query results to variables?
Explain the importance of .pll extension in oracle?
what is dynamic SGA and static SGA
How to write an inner join with the where clause in oracle?
What is not equal to in oracle?