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 difference between rank () row_number () and dense_rank () in sql?

0 Answers  

How do I remove sql plus from windows 10?

0 Answers  

what is data manipulation language? : Sql dba

0 Answers  

What type of database is cloud sql?

0 Answers  

Explain normalization and what are the advantages of it?

0 Answers  

How do you respond to dementia behavior?

0 Answers  

What is the basic structure of PL/SQL ?

6 Answers  

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

four procedures is are there should i write their in a package

2 Answers  

What does desc stand for?

0 Answers  

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

0 Answers  

what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

For more SQL PLSQL Interview Questions Click Here
Categories