Antipattern: Filling in the Corners

Let’s explore the issues that arise when using the Pseudo Key Neat-Freak antipattern for filling up the gaps.

There are two ways we might fill the perceived gap.

Assigning numbers out of sequence

Instead of allocating a new primary key value using the automatic pseudo key mechanism, we might want to make any new row use the first unused primary key value. This way, as we insert data, we naturally make gaps fill in.

Get hands-on with 1200+ tech skills courses.