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

Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?

Question Posted / guest

Answer Posted / guest

Presence of statistics in the data dictionary for atleast
one of the tables accessed by the SQL statements is
necessary for the OPTIMIZER to use COST-based approach.
Otherwise 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 to delete a column in an existing table?

1059

How to create a table index in oracle?

1113

What is the difference between Delete, Truncate and Drop in Oracle?

1106

How to write date and time literals in oracle?

986

How to rename a column in an existing table?

1015

How to view the tablespaces in the current database?

960

Can multiple columns be used in group by in oracle?

960

How to use subqueries with the in operator using oracle?

1070

Explain an integrity constrains?

1122

What is a subquery?

1102

Explain the use of show option in imp command.

1086

Explain the difference between a procedure and a function?

1143

When do we use group by clause in a sql query?

1024

How to resolve the ORA-39133 error in Oracle?

1093

How to select some columns from a table in oracle?

1064