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
- 4290 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
How to write numeric literals in oracle?
What the is the diff between local index and global index. give some example.
What is the data type of dual table?
How to lock and unlock a user account in oracle?
How is it different from a normal table?
How to see the table columns used in an index?
How to connect ms access to oracle servers?
What is the difference between a hot backup and a cold backup in oracle?
What is a cursor in oracle?
What is an oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
List out the types of joins.
How to create a new view in oracle?
What are the set operators union, union all, minus & intersect meant to do?
How to test null values?
