Help
Observation: No Index on Foreign Key
You have not defined an index for the columns that comprise a foreign key of a child table with key columns that match the definition of the primary key of the parent table. Though you are not required to define an index on a foreign key, DB2 can use an index to validate constraints that you define. Failing to define an index on a foreign key with leading columns that are identical in data type and order as those of the primary key can result in performance degradation. For example, when you DELETE rows from a parent table, DB2 effectively invokes a tablespace scan on each child table to validate the constraint.