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

How to create a table in a specific tablespace?

976

What is Undo Management Advisor in Oracle?

1099

Is there any function in oracle similar like group_concat of mysql?

1054

What are the general rules on data consistency?

1009

What is merge in oracle?

1055

How to convert character types to numeric types?

1137

what's query optimization and without use of IN AND Exist can we get another way data from query

2144

Can a parameter be passed to a cursor?

1127

What is oracle rowcount?

1088

What are the different types of trigger and explain its various uses and functions?

1097

In what script is snap$ created? In what script is the scott/tiger schema created?

2710

Explain the use of inctype option in exp command.

1034

Please explain joins in oracle?

1063

How to view existing locks on the database?

1054

Can we insert data in view oracle?

1042