16.10 -  Enabling Object Use Counts - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

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).