What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 3650 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 |
What are the data types in oracle?
Explain the use of online redo log files in oracle.
How to export your connection information to a file?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to retrieve first and last records from a table?
what are the different types of cursors? explain?
what are different types of locks?
How can I see all tables in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to pass parameters to procedures in oracle?
How to view existing locks on the database?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
Oracle General 
