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 the difference between dbm cfg and db cfg file in db2 ?
What is temporal table in db2?
When is the access path determined for dynamic SQL?
Which are the db2 tools to protect integrity of the database?
What is DCLGEN ?
Plan has the optimized access path in it. But is that optimized access path is attained or known
How many types of page locks can be held in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are column-name qualifiers used?
What language is db2 written in?
How would you print the output of an SQL statement from SPUFI?
What DB2 Catalog column tell you when an index needs table reorganized ?