A Retained Key is an integer used to represent a particular business key in a database table. It is useful in the following scenarios:

1. Optimising for speed of joins
2. Enabling business keys with null values
3. Handling co...