This question is about DB2 table design and performance.
We are using DB2 UDB Enterprise 8.2 on Linux.
We have 6 tables in a parent-child (one-to-many) relationship with each other. Each child table having an FK up to its parent. This particular design is motivated by our domain model.
A -> B -> C -> D -> E -> F
There is some debate in our team about how best to accomplish...