What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
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 Reduced List of Values?
What is parameterized cursor in oracle?
How to connect to a local oracle 10g xe server?
What are the different types of record groups in oracle? Explain each of them
Is oracle an operator?
How to write an inner join with the where clause in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain an exception and its types?
How to create lov dynamically at runtime & attach to text field?
what is meant by magic query
What is the difference between truncate & delete command?
How to save query output to a local file?
What is ordinary table in oracle?
State and explain the different types of data models?
How to generate query output in html format?