Tables are stored in Table Space (hence the name)! There are 3 sorts of Table Space simple, segmented and partitioned
An embedded Sql statement may come up with a lot of rows additonally the programming blabber can merely entrance one row at a opportunity The programming device labeled a cursor controls the position of the row .
Referential integrity refers to the consistency who are required to be maintained between number one and distant keys, ie most every out of country key quality ought to experience a corresponding number one key value.
I/O operations are mostly many grim for DB2 performance (or any a good deal more database for the current matter)
De-normalizing DB2 tables goes down the would like for processing intensive relational joins and decreases the sum of distant keys.