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
- 13262 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 data stream and data adaopter?
Explain a mapping, session, worklet, workflow, mapplet?
What is mapplet?
What are various warehousing tools?
What are Data Marts?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
Explain difference between view and materialized view?
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
Explain in simple terms, the concept of Data Mining.
What is data analysis?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Teradata 
