EnterWorks - ETT 151 - How to Reset Sequence Tables in EPIM and EPX Databases

The EnterWorks application uses sequence tables for determining the next ID for various tables in the EPIM and EPX databases.  Any time a new sequence number is needed, a row is inserted into the appropriate sequence table and retrieves the entity column value for that row to be used as the sequence.  The processing that performs this action doesn't remove the records from the sequence tables, which mean that over time, they can grow to millions and possibly billions of records that never need to be accessed beyond when they were created.

A SQL Stored procedure has been created to trim these tables in a manageable way (to avoid large transactions) which can significantly reduce the storage space required in the databases.  This stored procedure can be used periodically, such as on a monthly basis, to keep the sequence table sizes in check.

This session identifies the sequence tables, describes the stored procedure in detail including how to use it.

Prerequisites - ETT 073