Memory constraint is one of the key reasons for under-utilized processing power.

When a primary key constraint is defined, the federated system automatically creates a unique index specification.

This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.