Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / guest

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

Explain oracle data types with examples?

1028

Explain database link?

1123

Explain an index?

1134

Difference between open_form and call_form in oracle.

1161

What are a cluster and non-cluster index?

1018

How to rename an index in oracle?

1114

What are ddl statements in oracle?

1075

How to delete a user account in oracle?

973

Explain the use of log option in exp command.

1121

What is the difference between primary key and unique key and foreign key in oracle?

982

Explain what are the uses of rollback segment?

1015

What is ceil and floor in oracle?

1069

State and explain about oracle instance?

991

How many categories of data types in oracle?

1029

What are the differences between number and binary_float in oracle?

1100