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 "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Question Posted / guest

Answer Posted / guest

The Optimizer chooses Cost_based approach and optimizes with
the goal of best throughput if statistics for atleast one of
the tables accessed by the SQL statement exist in the data
dictionary. Otherwise the OPTIMIZER chooses RULE_based
approach.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain integrity constraints?

1109

How to save query output to a local file?

1030

How to convert a date to char in oracle? Give one example.

1073

What is the data pump export utility?

1086

 How to use an oracle sequence generator in a mapping?

1078

What do you understand by database schema and what does it hold?

1232

how to handle exceptions in post production

1432

What is snapshot is too old? Give and example for better understand.

1607

What is a table index in oracle?

1131

Is oracle a language?

953

How to delete a user account in oracle?

979

How to use in conditions in oracle?

1058

How to define an anonymous block?

1162

What is the difference between online and offline backups?

1061

How to use "in" parameter properly?

1077