Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 4294 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 |
What is COST-based approach to optimization ?
How many data types are supported?
What is STATSPACK tool?
What is the usage of merge statement?
What is the difference between online and offline backups?
What is a OUTER JOIN?
What happens if you set the sga too low in oracle?
what is the use of composite key constraint?
What is a Private Synonyms ?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
Is oracle an operator?
What is meant by recursive hints ?
Oracle General 
