Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 4463 Views
- I also Faced
- E-Mail Answers
Answer / guest
This value causes the optimizer to 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 throughput.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a subquery in oracle?
Difference between NO DATA FOUND and %NOTFOUND?
How to create a table index?
How to resolve the ORA-39133 error in Oracle?
What is a server parameter file in oracle?
how to tune oracle sql queries pls tell me step by step. urgent pls
What is a table index?
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
What happens to the current transaction if the session is killed?
How to invoke the original export import utilities?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is the difference between "as" and "is" in an oracle stored procedure?
Oracle General 
