Interested to Buy Any Domain ? << Click Here >> for more details...
what is query optimizer? what are different types of
optimizer s supported by oracle ?
- 1 Answers
- 13255 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 a static and local variable?
Are facts same as metrics and dimensions same as measures? If not , please tell the difference?
what role views play in dimensional modeling?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
Can any one explain the hierarchies level data warehousing.
what are the others of "bad files" and "discard files" when using sql*loader?
How did you plan your Data ware house project?
What is prompt types of prompts?use of prompts syntax of prompt?
What is the advantages data mining over traditional approaches?
What is difference between model & package?
What is source qualifier?
Explain why dimenstion tables are denormalized in nature?
Teradata 
