What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 3956 Views
- I also Faced
- E-Mail Answers
Answer / guest
This value causes the optimizer to use 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 response time.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to convert a date to char in oracle? Give one example.
What is the difference between Sleep and Wait? (Java)
What would you use to improve performance on an insert statement that places millions of rows into that table?
what is the difference between UNION AND UNIONALL
How to call a sub procedure?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to resolve name conflicts between variables and columns?
What is a Public Synonyms ?
how to retrive xml data for using sql query?
how to get the second max val for every group in a table
What are the components of Physical database structure of Oracle Database?
How to connect to the server with user account: sys?
Oracle General 
