Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is the maximum number of tables that can be joined ?




443
views
asked mar September 2, 2014 11:22 AM  

What is the maximum number of tables that can be joined ?


           

1 Answers



 
answered By Mswami   0  
According to IBM documentation, Maximum number of tables referenced in an SQL statement: 1000.

Provided, the maximum number of members (and partitions) referenced is also 1000. In DELETE and UPDATE statements the maximum number is 256.

Note: From DB2 V8, You can have the maximum up to 225 Tables. 
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert