What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1629


What to do if dba lost the system password?

866


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2089


Will you be able to store pictures in the database?

920


When system tablespace is created?

811


What is the difference between count (*), count (expression), count (distinct expression)?

809


Why does for update in oracle 8 cause an ora-01002 error?

770


What is columnar storage what is the advantage?

767


What is meant by joins? List out the types of joins.

753


11. Display the client number and name and the client number and name of the person who referred that client.

2117


What is the relation of a user account and a schema in oracle?

865


Explain the difference between sap and oracle?

794


Differentiate between pre-select and pre-query?

863


Can we store images in oracle database?

765


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1930