View previous topic :: View next topic
|
Author |
Message |
ruchin2005
New User
Joined: 06 Oct 2006 Posts: 2
|
|
|
|
Hi all,
I want to know what is the maximum no of table that we can join in Db2.
Thanks |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Not sure...
But...
225 or fewer, depending on the complexity of the statement |
|
Back to top |
|
|
raviprasath_kp Warnings : 1 New User
Joined: 20 Feb 2005 Posts: 65 Location: chennai
|
|
|
|
i hope maximum 16 |
|
Back to top |
|
|
ruchin2005
New User
Joined: 06 Oct 2006 Posts: 2
|
|
|
|
Thanks to all for ur quick reply. |
|
Back to top |
|
|
Suresh Ponnusamy
Active User
Joined: 22 Feb 2008 Posts: 107 Location: New York
|
|
|
|
IN DB2 V7
You can have the maximum upto 15 Tables
But in DB2 V8
You can have the maximum upto 225 Tables |
|
Back to top |
|
|
|