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...

What is COST-based approach to optimization ?

Answer Posted / tony

Cost Based Optimizer (CBO) - This method is used if
internal statistics are present. The CBO checks several
possible execution plans and selects the one with the
lowest cost, where cost relates to system resources.

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 use "in" parameter properly?

1074


How to declare a local variable?

1125


Is truncate autocommit in oracle?

1087


What are group functions in oracle?

1043


What to do if the binary spfile is wrong for the default instance?

1071


What is the difference between substr & instr functions?

1231


Explain what are the uses of rollback segment?

1017


How to resolve the ORA-39133 error in Oracle?

1123


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2294


Explain the use of grant option in imp command.

1030


What are the differences between lov and list item?

1069


How to use "out" parameter properly?

1083


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1944


Can a formula column be obtained through a select statement ?

2330


11. Display the client number and name and the client number and name of the person who referred that client.

2339