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 scalar and vector?

0 Answers  

What is cross join sql?

0 Answers  

Which join is like inner join?

0 Answers  

..........refers to the disk mirroring

2 Answers   iFlex,

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

What is the life of an sql statement?

0 Answers  

Why do we need databases?

0 Answers  

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

What do you understand by pl/sql cursors?

0 Answers  

Is sqlexception checked or unchecked?

0 Answers  

what are wild cards used in database for pattern matching ? : Sql dba

0 Answers  

Is grant a ddl statement?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories