what is query optimizer? what are different types of
optimizer s supported by oracle ?
- 1 Answers
- 12908 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 Drill by? drill through?
Explain difference between view and materialized view?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What is surrogate key? Explain with examples.
Explain er diagram?
What are fundamental stages of data warehousing?
what is table partitioning? How it is useful to warehouse database?
if you use oracle sql*loader , how do you transform data with it during loading?
Explain what is real time data-warehousing?
What are the design methods of data warehousing?
What is a look up function? What is default transformation for the look up function?
Explain what are necessary tasks to install reportnet software?
Teradata 
