Interested to Buy Any Domain ? << Click Here >> for more details...
what is query optimizer? what are different types of
optimizer s supported by oracle ?
- 1 Answers
- 13328 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 difference between drill & scope of analysis?
Can we have multiple application.cfm file in an application?
Explain er diagram?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
three ways sql*loader could load data, what are those three types?
What are various warehousing tools?
Explain what is a cube in data warehousing concept?
What are different deliverables according to phases?
What is the difference between data warehouse and operational systems?
What is a linked cube?
What is type 2 version dimension?
what is parallel query?
Teradata 
