what is query optimizer? what are different types of
optimizer s supported by oracle ?
- 1 Answers
- 12559 Views
- ABC, I also Faced
- E-Mail Answers
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 the use of incremental aggregation? Explain me in brief with an example?
Explain what are the mapping paramaters and maping variables?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What are non-additive facts in detail?
What is factless fact tables?
Which are the olap tools available that are supported by oracle?
Explain what are the various file formats involved in reportnet?
How to create different types of templates?
What are the reasons to use a chameleon method in data warehousing?
What is meant by metadata in context of a data warehouse and how it is important?
I need a good brd and uc template?
What are CUBES?
Teradata 
