17.00 - 17.05 -  Enabling Object Use Counts - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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.

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

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