what is query optimizer? what are different types of
optimizer s supported by oracle ?
- 1 Answers
- 12854 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 |
List any five applications of data warehouse.
How to create different types of templates?
what is the difference between etl tool and olap tools
Best Data Ware housing training institute in delhi
What is recovering sessions?
Best institute for MS BI training in Hyderabad, India?
Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K
6 Answers Accenture, IBM, TCS,
WHAT IS FACT LESS FACT TABLE?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
in general which algorithms for used?
What is difference between Mapplet and reusable transformation?
What a static and local variable?
Teradata 
