what is query optimizer? what are different types of
optimizer s supported by oracle ?
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
Explain what is analytical or analytic mean?
Explain what is the difference between datawarehouse and bi?
What are the various methods of getting incremental records or delta records from the source systems?
What is the extension of file to save template?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
How to stop a batch?
Explain what are the tasks that loadmanger process will do?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Explain what are the various file formats involved in reportnet?
What are aggregate transformation?
What are the advantages of raid 1, 1/0, and
I know of using applysimple, but there are other ways too?
What are the different types of fact tables used in data warehousing?
Explain what is a cube in data warehousing concept?
What is the difference between olap and datawarehosue?