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

Answer Posted / mahesh

For running any quey requires or generates an execution pan
before actually fetching data

in cost based approach, the oracle will generates the
execution plan based on available statistics.

oracle supports cost based approcach and it is continuously
improving fron one version to another version of oralce
database

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 initialize variables with default values?

1157

How to use "in out" parameter properly?

998

How to drop an existing table in oracle?

1012

What is oracle sid?

887

How many categories of data types in oracle?

953

How to start your 10g xe server?

970

What happens in oracle commit?

970

What is oracle datasource?

924

What is oracle database client?

974

What is an anonymous block?

1155

How to define a cusotmer as a supplier in ORACLE R12

2168

How to Truncate Table in Oracle

1091

What is define in oracle?

998

What are the types of partitions in oracle?

974

What is a cursor in oracle?

1106