Example: Using InsertUseCountV - Advanced SQL Engine - Teradata Database

The following SELECT statement shows the number of inserts occurring on a particular object:

SELECT InsertCount FROM DBC.InsertUseCountV WHERE DatabaseName = 'Personnel' AND ObjectName = 'Employee';

Result:

InsertCount
------------
9