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
How does a cursor work?
What are the uses of db2 optimizer?
Which component is responsible for processing sql statements and selecting access paths?
What is innodb buffer pool?
What is the role of union all and union
Are views updateable?
What is the syntax for creating a table in the db2 database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is a db2 cursor?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Explain in brief how does db2 determine what lock-size to use?
What is cursor stability in db2?
Which is faster delete or truncate?
What do you mean by rollback?
What is netezza database?