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 are date and time intervals? : Sql dba

1105


What is schema in sql example?

1278


Can a foreign key be null?

1144


What are the qualities of 2nf?

1096


How can we implement rollback or commit statement in a trigger?

1085


Can we write ddl statements in functions?

1183


How does postgresql compare to oracle/db2/ms sql server/informix?

1094


Does sap use sql?

1041


What is trigger types in sql?

1044


Does pl/sql support create command?

1168


How many types of literals are available in pl sql?

1166


What is triggering circuit?

1105


What do you think about pl/sql?

1125


What is the use of desc in sql?

1022


Define SQL and state the differences between SQL and other conventional programming Languages?

1265