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
- 13326 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 Non-additive facts?
How to reduce warnings?
Could any one explain me how to create cascading prompts?
what are relationships?
Explain is fact table?
What is the definition of cube in datawarehousing?
Explain what is the difference between powerplay transformer and power play reports?
Tell me what is full load & incremental or refresh load?
How to limit the max no of rows retrieved in the report?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What are the advantages of query studio compared to report studio?
What is surrogate key? Explain with examples.
What is the difference between view materialized view and view?
what are different storage options supported by oracle ?
What are session timeout and application timeout? Where we have to do this process?
