What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
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 |
How do I manually create a database in oracle?
How to create a new table in your schema?
What is an UTL_FILE.What are different procedures and functions associated with it?
Explain the use of Merge statement in oracle 11g
what are stored procedures?
why can't we assign not null constraint as table level constraint
How to do paging with oracle?
what is index?
How to define a record variable to store a table row?
Explain the use of show option in imp command.
What is sharded cluster?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.