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 rule base and cost base optimizer?

Answer Posted / chandra shekher

Rule based optimiser will optimise the query based on the
rules.

Cost based optimiser will optimise the query based on the
statistics available for the table.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle pl sql developer?

987


What is full form of rtm?

1011


Define sql delete statement.

1016


What are %type and %rowtype for?

1057


Why trigger is used in sql?

977


Does google use sql?

970


What is meant by user defined function?

1056


What is sql server and ase?

1031


what is an extent ? : Sql dba

1107


how to do backup entire database? : Transact sql

1149


Is merge a dml statement?

984


What is a left join?

961


What is a common use of group by in sql?

1051


what is the command line end user interface - mysql? : Sql dba

985


Explain what is table in a database?

1065