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
- 4418 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 named parameters?
What is the usage of control file in oracle?
What is Public Database Link ?
what is the difference between restoring and recovering?
How to use "out" parameter properly?
Can the query output be sorted by multiple columns in oracle?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
How to unlock the sample user account in oracle?
What is oracle sid?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to handle a single quote in oracle sql?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Oracle General 
