what is the maximum number of tables that can be joined ?
Answer Posted / jitinder
IN DB2 V7
You can have the maximum upto 15 Tables
But in DB2 V8
You can have the maximum upto 225 Tables
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is bind package and plan in db2?
Explain package in db2 and its advantages?
What is concurrency?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is dbrm? What it contains?
What is dbrm library?
What is netezza database?
What does reorg do in db2?
Explain what are the various isolation levels possible?
How to retrieve rows from a db2 table in embedded sql?
What do you mean by cursor?
How do I delete a table in db2?
Is it possible using max on a char column?
What does a deadlock mean in DB2?
How to get the ddl of a table in db2?