what is query optimizer? what are different types of
optimizer s supported by oracle ?
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is metadata reporter?
What are the different methods of loading dimension tables?
Database in use is oracle?
What are the various file formats involved in reportnet?
Explain difference between snow flake and star schema.
I need a good brd and uc template?
What is a view as it relates to system modeling?
What is hybrid slowly changing dimension?
What is the metadata extension?
What are the different types of segments?
Explain vldb?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is defined as partial backup?
What is analytical or analytic mean?
Explain what is real time data-warehousing?