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 a ETL/ How does Oracle support the ETL process?
What are the primary ways to store data in OLAP?
How can Oracle Materialized Views be used to speed up data warehouse queries?
What is difference between query studio and report studio?
what are different types of partitioning in oracle ?
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
Explain if a flat file cotains 1000 records how can I get first and last records only?
What are the different types of data warehousing?
Explain the importance of data warehouse?
What is normalization, first normal form, second normal form, third normal form?
How to generate the cubes in framework manager?
What is confirmed dimension?