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 |
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
Compare and contrast aggregates & indexes
What is many-to-many dimensional model in datawarehousing ?
Explain what is fact less fact table? Where you have used it in your project?
What is a relationship?
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?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
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?
What is the advantages data mining over traditional approaches?
What is a full backup?