What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 3904 Views
- I also Faced
- E-Mail Answers
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
What is dynamic proxy?
what is IDE,DMV in sql server?
What is blob datatype?
What do you know about normalization? Explain in detail?
How many file formats are supported to export data?
How to create a new table by selecting rows from another table?
How to select some rows from a table in oracle?
How can windows applications connect to oracle servers?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to use "while" statements in oracle?
What are the set operators union, union all, minus & intersect meant to do?
What is Virtual Private Database in Oracle?
What are the numeric comparison operations?
Can we insert data in view oracle?
What is the dynamic sql in oracle?
