What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 3577 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 |
Can u make a synonym for deptno=10 only from emp table.
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
ABOUT IDENTITY?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to recover a dropped index?
select statement does not retrieve any records. what exception is raised?
what is a view?
Explain the use of inctype option in exp command.
Is there an oracle sql query that aggregates multiple rows into one row?
What is different types of joins?
What is max rowid in oracle?
How are extents allocated to a segment?
Oracle General 
