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 cursor?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What are the full forms of spufi and dclgen and why are they used?
How to run db2 command in windows?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
what is datacom db?
What does the sqlcode of -818 pertain to?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
Which are the db2 tools to protect integrity of the database?
Can we able to find all the Table names under a Particular Plan?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What are the functions of Bind?