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
- 4375 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 memory advisor in Oracle?
can u call user defined functions in select statements
Why do we use coalesce function in oracle?
What do database buffers contain?
How to rename a tablespace in oracle?
How many types of segments in Oracle?
What is a Shared SQL pool ?
What are privileges and grants?
What happens if the update subquery returns multiple rows?
What are various joins used while writing SUBQUERIES?
How data locks are respected in oracle?
Does facebook use oracle?
Oracle General 
