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
- 1644 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do you check for a null value in a db2 column?
Plan has the optimized access path in it. But is that optimized access path is attained or known
What is syscat in db2?
What is check constraint. Explain with example.
Can we able to find all the Table names under a Particular Plan?
What is the default page size of buffer pools?
what is db2 restart?
Which components manage deadlocks in db2?
wht happens if we close cursor with cursor with hold option?
What is multi row fetch in db2?
How to fetch the uncommited data from table ?
Where is the output of EXPLAIN stored?
COBOL 
