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 |
What is Trace File ?
What are the logical operations?
What are the differences between primary key and unique key?
How does the on-delete-cascade statement work?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the difference between a user and a schema in oracle?
How do I connect to oracle?
am completed mca2011 how get certification in oracle
How to define a record variable to store a table row?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
What is a package ? What are the advantages of package ?
How to create a new tablespace in oracle?