what is query optimizer? what are different types of
optimizer s supported by oracle ?
- 1 Answers
- 12878 Views
- ABC, I also Faced
- E-Mail Answers
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
What are the types of partitioning?
Compare and contrast aggregates & indexes
Explain why fact table is in normal form?
How can we load the time dimension?
Explain what is cost benefit analysis (cba)?
Explain what does level of granularity of a fact table signify?
Explain difference between e-r modeling and dimentional modeling?
Explain difference between snow flake and star schema.
How are the dimension tables designed?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is the function of surrogate key in data warehousing?
What is surrogate key? Where we use it? Explain with examples.
Difference between cold fusion 5 and cold fusion mx 6?
Explain the hierarchies level data warehousing.
What is difference macros and prompts?
