what is query optimizer? what are different types of
optimizer s supported by oracle ?
- 1 Answers
- 12882 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 |
Explain if a flat file cotains 1000 records how can I get first and last records only?
What are session timeout and application timeout?
State any 5 of Cods guidelines of an OLAP system, brief description each?
Explain what are components of report studio?
What is meant by metadata in context of a data warehouse and how it is important?
What is critical column?
What is execution plan?
How do we design a universe?
How to design file watch jobs?
What is a data profile?
What is VLDB?
What is the advantages data mining over traditional approaches?
Teradata 
