Enabling Object Use Counts - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

 Enabling Object Use Counts

To enable object use counts, use the WITH USECOUNT option of the BEGIN/REPLACE QUERY LOGGING request. This request starts collection of object use counts in the Data Dictionary table DBC.ObjectUsage. Object use counts are disabled by default, but it is a best practice to enable them for production databases to ensure the accuracy of automated statistics.

Teradata Database tracks two versions of these counts, which collect identical information:

  • User counts (a user can reset).
  • System counts (only the system can reset).