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
What is meant by explain?
How can you quickly find out the # of rows updated after an update statement?
What does the REORG Utility do?
Return code 100 means?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How Plan is created while executing the query using SPUFI?
pls explain the precompilation process of cobol-db2 pgm
What is the difference between spufi and qmf?
Q3. How will you fetch duplicate values from a DB2 table?
What is DYNSLT keyword? How do you perform selection using DYNSLT
What is page size in db2?