What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
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 split the print reviewer into more than one region ?
Explain the use of rows option in exp command.
 How to use an oracle sequence generator in a mapping?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Difference between cartesian join and cross join?
What is oracle join syntax?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
What is an Index ? How it is implemented in Oracle Database ?
what are actual and formal parameters?
How to create a table index in oracle?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
How to use group functions in the select clause using oracle?