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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is rule base and cost base optimizer?

Question Posted / akshay

Answers were Sorted based on User's Feedback



What is rule base and cost base optimizer?..

Answer / 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

What is rule base and cost base optimizer?..

Answer / chandra bhusan prasad

one is supported in 8i and another in 9i/10g
cost base optimizer display the cost attributes of query
and it is easier.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

What is linq to sql?

0 Answers  

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

What do you mean by rowid?

0 Answers  

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

Why do we need databases?

0 Answers  

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

what is overloading procedure or overloading function ?

3 Answers   Genpact,

What is difference between inner join and cross join?

0 Answers  

How to write pl sql program in mysql command prompt?

0 Answers  

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

What is clustered index sql?

0 Answers  

What are the three pl sql block types?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories