I understand Join always perform better than subqueries.
Then what is the advantage/use of Subqueries/correlated
subqueries etc.,in DB2 programming.Please explain.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

When the like statement is used?

0 Answers  


if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  


Is db2 a programming language?

0 Answers  


What is an inner join, and an outer join ?

1 Answers   CTA,


What is the difference between plan and package in db2?

0 Answers  






What is cursor stability?

1 Answers  


What are the prerogatives?

0 Answers  


What is the purpose of using commit?

0 Answers  


how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,


What db2 400?

0 Answers  


How to compare data between two tables in db2?

0 Answers  


What will the FREE command do to a plan?

2 Answers  


Categories