Antipattern: Filling in the Corners

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.