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

What is the data type of dual table?

1061

Is java required for oracle client?

1043

How do I connect to oracle database?

1193

Explain an exception and its types?

1134

How to Truncate Table in Oracle

1209

What is a tns service name?

1054

What are oracle functions?

1086

What is difference between cartesian join and cross join?

1151

How to define a sub function?

1195

How to convert characters to numbers in oracle?

1111

What privilege is needed for a user to create indexes in oracle?

1078

Is oracle an operator?

982

What is different types of joins?

1078

How to create a new table by selecting rows from another table?

1145

Why is oracle so popular?

1051