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
- 4388 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 transport network substrate (tns) in oracle?
What is max rowid in oracle?
Is java required for oracle client?
How to sort output in descending order in oracle?
What is rich query?
What happens if you use a wrong connect identifier?
How to write text literals in oracle?
How much memory your 10g xe server is using?
What are the different windows events activated at runtime ?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What is analyze command used for?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is Reduced List of Values?
What is a cognitive schema?
What is an oracle and why it is used?
