what is query optimizer? what are different types of
optimizer s supported by oracle ?
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 the difference between an ODS and a W/H?
What is difference between e-r modeling and dimensional modeling?
Explain normalization?
What is the metadata extension?
What are the methodologies of data warehousing?
What is a source qualifier?
What are components of report studio?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What is an er diagram?
What are various warehousing tools?
What are Non-additive facts?
what is indexing ? what are different types of indexes supported by oracle ?