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
- 13266 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 |
How to improve session performance in aggregator transformation?
What is difference between Mapplet and reusable transformation?
Explain the difference between filter and conditin?
How to add a number to a macro variable?
Which component has onread method and what it is used for?
Explain what does level of granularity of a fact table signify?
How to generate iqd file from framework manager?
Name at least three brands of Database Management Systems
Explain Association algorithm in Data mining?
Explain what are necessary tasks to install reportnet software?
Difference between cold fusion 5 and cold fusion mx 6?
Why do we use DSS database for OLAP tools?
Teradata 
