Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 4500 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
When do I need to use a semicolon vs a slash in oracle sql?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Explain the use of compress option in exp command.
What is a directory object?
What is bulk collect in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is an oracle function?
Explain the characteristics of oracle dba?
what is normalisation?what are its uses?
How to use "out" parameter properly?
What are the various types of snapshots ?
What is the usage of control file in oracle?
What is the difference between pre-select and pre-query?
What is a dead lock in oracle?
Can we protect our pl/sql source code?
