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 COST-based approach to optimization ?

Question Posted / mkjmkumar

Answer Posted / mkjmkumar

Oracle Analyse a Query using two Approches
1. CBO
2. RBO

Cost Based Analyser is default when we do not in oracle
setup.

CBO picks up query output using witch have less cost

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2249

How can we force the database to use the user specified rollback segment?

1119

How to convert characters to numbers in oracle?

1047

How to define a data source name (dsn) in odbc manager?

1009

What is a select query statement in oracle?

944

How to retrieve values from data fields in record variables?

1088

What is a trigger and what are its types?

1199

What is literal?

987

How to define a cusotmer as a supplier in ORACLE R12

2212

State and explain the different types of data models?

925

How to create a new user account in oracle?

994

how may join possible between (requisition with purchase order)

2232

Name the various constraints used in oracle?

1001

What is a subquery?

1103

How to use existing values in update statements using oracle?

1044