what is query optimizer? what are different types of
optimizer s supported by oracle ?
- 1 Answers
- 12573 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 DTM session?
Which kind of index is preferred in DWH?
How are models actually derived?
What is operational data source (ODS)?
What are the data types present in bo? What happens if we implement view in the designer n report?
What are data modeling and data mining? Where it will be used?
what are the major three types of modeling used?
0 Answers InfoAxon Technologies,
What is the difference between olap and datawarehosue?
What is the difference between agglomerative and divisive hierarchical clustering?
What is critical column?
What is cubes?
what are the others of "bad files" and "discard files" when using sql*loader?
Teradata 
