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

Explain the blob datatype?

1058


List out the components of logical database structure of oracle database.

1011


What is a snapshot in oracle database?

1004


How to list all indexes in your schema?

1078


How to install oracle database 10g xe?

997


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

987


defination of bitmap index

2096


What are group functions in oracle?

1016


What is varray?

1110


How to upsert (update or insert into a table)?

986


How to retrieve the count of updated rows?

1107


How to set up autotrace for a user account?

1033


What is an oracle and why it is used?

1128


Will you be able to store pictures in the database?

1093


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5507