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

What is the dynamic sql in oracle?

1082

What is recycle bin in Oracle?

1154

What is coalesce function?

1078

How to grant create session privilege to a user in oracle?

1005

How many types of cluster table in Oracle?

1034

How to sort the query output in oracle?

1029

Explain oracle instance.

1185

definition of cluster and non-clustered index?

3035

How to get execution path reports on query statements?

990

Can the query output be sorted by multiple columns in oracle?

995

What are the various oracle database objects?

1148

How to convert numbers to characters in oracle?

1033

What are oracle functions?

1035

Why does oracle 9i treat an empty string as null?

1063

What is data block in Oracle?

1118