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
- 13244 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 |
What is a hash cluster?
How can you set the session management?
What is static and local variable?
What are the approaches used by optimizer during execution plan?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is your spectra photometer working principles?
What is the difference between view materialized view and view?
Database in use is oracle?
What is Star Schema?
What are the steps involved in designing a fact table?
What is multi-dimensional analysis?
Explain what are the different types of join operations?
Teradata 
