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 integrity in sql?

1023


What is the use of %rowtype?

1025


Is it possible to sort a column using a column alias?

1026


Is primary key always clustered index?

993


How do I debug a stored procedure?

1095


What is the maximum rows in csv?

911


What is sql not null constraint?

1010


Which constraints we can use while creating database in sql?

1058


How do I run a query in pl sql developer?

976


What is set transaction?

1019


What is oracle sql developer?

1029


how to create a new table by selecting rows from another table in mysql? : Sql dba

1065


When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1092


What is trigger explain with example?

1016


What is null in pl/sql?

1047