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 |
Explain what is the difference between stop and abort?
Suppose we want to display zero when null values coming to report how can we do that?
Explain what are the different methods of loading dimension tables?
Explain what are fact, dimension, and measure?
How to load the time dimension?
How can we determine what records to extract?
What is Bulk Insert?
What is operational data source (ODS)?
What are parallel querys and query hints?
wht is degenerated dimension ?it's uses?
Hierarchy of DWH?
2 Answers Accenture, EDS, IBM, iFlex, TCS,
What is the difference between view materialized view and view?