Enabling Object Use Counts - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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