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 / nishi

Answer Posted / nishi

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

How can I see all tables in oracle?

1011

How view is different from a table?

1041

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

How to convert character types to numeric types?

1137

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2288

What are the extensions used by oracle reports?

1039

Write a syntax for update query in oracle?

1036

What does sharding mean?

1007

Explain an index?

1140

How to open a cursor variable?

1040

How to fetch the row which has the max value for a column?

1002

What is backup in Oracle?

1006

How to start instance with a minimal initialization parameter file?

1045

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007

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

1004