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

What are a cluster and non-cluster index?

1064


Explain about your project and its relation to the current job position you are applying to?

1075


How to use null as conditions in oracle?

1125


What is the difference between sharding and replication?

1135


How to count groups returned with the group by clause in oracle?

1122


What is an oracle wallet?

988


How to estimate disk space needed for an export job?

1105


Explain the characteristics of oracle dba?

1175


How to check your oracle database 10g xe installation?

1048


How to count duplicated values in a column in oracle?

1105


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1128


What is rich query?

1035


How are extents allocated to a segment?

1181


What is an oracle user role?

1040


Can we save images in a database and if yes, how?

1109