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
- 13171 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 |
How can you communicate with web server (apache or iis) from coldfusion?
What is the function of surrogate key in data warehousing?
How to pivot data using informatica when you have variable amount of pivot rows?
In document how to create metrics?
What is the difference between filter and lookup transformation?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
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 meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
How to join 3 database like flat file, oracle, db2 in informatrica?
What is BCP?
How do you setup Lo-cockpit?
How are the dimension tables designed?
Explain what are the various file formats involved in reportnet?
Teradata 
