What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 4523 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to create a stored program unit?
How to insert a record into a table?
What are steps required to ENTER DATA INTO DWH?
how may join possible between (requisition with purchase order)
What is merge statement used for?
How to delete a column in an existing table?
when loggined as SYSTEM,how to display all the users of database using sql query?
How to run create database statement again?
Where is the export dump file located?
Can objects of the same Schema reside in different tablespaces.?
What is oracle rownum?
What are the components of Logical database structure of ORACLE database?
Oracle General 
