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

How to prepare for oracle pl sql certification?

1105


What is dynamic query?

1028


what is the difference between rownum pseudo column and row_number() function? : Sql dba

1130


Why we use cross join?

997


Is microsoft sql free?

1138


explain the difference between bool, tinyint and bit. : Sql dba

1058


What is structural independence and why is it important?

1071


How does one load ebcdic data? : aql loader

1253


Give the order of sql select?

1180


Why having clause is used in sql?

1018


what are the limitations of identity column? : Transact sql

1158


Can delete statement be rollbacked?

1031


Mention what pl/sql package consists of?

1037


What is a temporal table?

975


What is pl sql script?

1078