Overview The process of adding and more specifically deleting records from the database over time results in a large number of gaps in tables’ identifier sequence number. It may be desirable to know where the breaks are, perhaps to re-use the numbers following identification of duplicates that need renumbering or where a bulk insert is required, or perhaps to identify gaps in a cheque sequence, or analyze potential issues with the database programs creating gaps invalidly.
