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 / tony

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 convert a date to char in oracle? Give one example.

1109

How different is ms access and oracle?

1089

Explain the use of Merge statement in oracle 11g

1076

How to select an oracle system id (sid)?

1121

Explain coalesce function?

1250

Can we create trigger on materialized view in oracle?

1044

What is the difference between translate and replace?

1118

How to create an initialization parameter file?

1106

How many types of auditing in Oracle?

1086

what happened to the global index when I truncate the data in one of the partition?

2066

How to declare a local variable?

1173

What is oracle instant client?

1067

State the various uses of dbcc command?

1105

How to lock and unlock a user account in oracle?

1160

What are the various constraints used in oracle?

1096