I am writing this after returning from my busy schedule. When I am just relaxing with coffee (my favourite), I got superb idea to write some db2 questions.
Q1) Correlated subquery top-bottom-top approach
Q2)Non correlated subquery bottom-to-top fashion
Q3) Joins are performance worth than Subqueries.
Q4) Usage of ‘OR’ is preferable than UNION
Q5) The “=” states in where clause, is FULL OUTER JOIN
wait for my next questions..