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
- 4423 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 |
Is it possible to disable the parameter from while running the report ?
How will you write a query to get a 5th rank student from a table student_report?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
What is the use of aggregate functions in oracle?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
What is a shared pool?
Can objects of the same Schema reside in different tablespaces.?
What are the various constraints used in oracle?
What is PL/SQL ?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
what is normalisation?what are its uses?
Oracle General 
