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 surrogate key? Where we use it explain with example?
Explain a mapping, session, worklet, workflow, mapplet?
In document how to create metrics?
What are the primary ways to store data in OLAP?
what is parallelism?
how do you use commit frequencies? how does it affect loading performance?
How to drill through from a powerplay cube to reportnet?
Explain the difference between view and materialized view?
How to pivot data using informatica when you have variable amount of pivot rows?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Explain the difference between data ware house & data mart?
What is the difference between filter and lookup transformation?