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
Where the applications and where ware house management system is used?
What are the other names given to data warehousing?
Explain dimension table ?
What is Sequence clustering algorithm?
How do you define data block size?
What is factless fact tables?
How to drill through from a powerplay cube to reportnet?
Explain multivalued dependency?
Explain what are necessary tasks to install reportnet software?
What are the stages of datawarehousing?
What is many-to-many dimensional model in datawarehousing ?
How to eliminate duplicate rows from flat file?
What is the difference between star and snowflake schemas?
Where we use surrogate key explain with example?
Explain swot analysis?