what is query optimizer? what are different types of
optimizer s supported by oracle ?



what is query optimizer? what are different types of optimizer s supported by oracle ?..

Answer / subhendu

The query optimizer is the component of a database
management system to optimize the query. Query optimization
is a function of many relational database management
systems in which multiple query plans for satisfying a
query are examined and a good query plan is identified.


Oracle supports two different Oracle query optimizers, a
rule-based optimizer and a cost-based optimizer. With
Oracle Database 10g, the rule-based optimizer is
desupported.

Is This Answer Correct ?    27 Yes 1 No

Post New Answer

More Data Warehouse General Interview Questions

what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-

4 Answers  


Compare and contrast aggregates & indexes

0 Answers   IBM, TCS,


What is many-to-many dimensional model in datawarehousing ?

0 Answers  


Explain what is fact less fact table? Where you have used it in your project?

0 Answers  


What is a relationship?

0 Answers  






If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

3 Answers   Extech, Principal Finance,


Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

0 Answers  


How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

0 Answers  


What is the difference between a data warehouse and a data mart?

15 Answers   Apex, ASD Lab, Bank Of America,


How did you plan your Data ware house project?

0 Answers   TCS,


What is the advantages data mining over traditional approaches?

0 Answers  


What is a full backup?

0 Answers  


Categories