what is query optimizer? what are different types of
optimizer s supported by oracle ?
Answer Posted / 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 View All Answers
Explain difference between view and materialized view?
What is a linked cube?
What is partitioning? What are the types of partitioning?
How do you create surrogate key using ab initio?
What is informatica architecture?
What a static and local variable?
Explain what are the advantages data mining over traditional approaches?
can anybody mail me the FAQS for hyperion essbase amd planning
Explain what is the difference between view filter and report filter?
What is a core dimension?
What is surrogate key? Where we use it explain with example?
What are the data types present in bo? What happens if we implement view in the designer n report?
What is the difference between data warehouse and operational systems?
List down some of the real time data-warehousing tools?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?