what is query optimizer? what are different types of
optimizer s supported by oracle ?
- 1 Answers
- 12856 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 is the use of tabular model, tabular sql, tabular reference in real time application?
Explain what are the possible data marts in retail sales?
What is incremintal loading?
What are the types of dimensional modeling?
What is the difference between connected and unconnected stored procedures?
Explain what are components of reportnet?
What is analytical or analytic mean?
Why denormalization is promoted in universe designing?
What are the different types of fact tables used in data warehousing?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Explain what is the difference between view filter and report filter?
Explain why should you put your data warehouse on a different system than your oltp system?
What is surrogate key? Explain with examples.
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
How to reduce warnings?
