I understand Join always perform better than subqueries.
Then what is the advantage/use of Subqueries/correlated
subqueries etc.,in DB2 programming.Please explain.
- 0 Answers
- 1835 Views
- I also Faced
- E-Mail Answers
More DB2 Interview Questions
How do I copy a table in db2?
what is the difference between declaring the cursor in WS section and Procedure division?
What is a db2 cursor?
what is the role of the cursor in db2?
What is plan in cobol db2?
What does reorg do in db2?
Why do we use cursor?
How can you display the current date & current time ?
What is check constraint. Explain with example.
What are db2 tables?
What is REORG? When is it used?
Before you give the explain statement, what are the prerogatives?
COBOL 
