15.00 - 15.10 - Database Object Use Count - Teradata Database

Teradata Database Introduction to Teradata

Teradata Database
Release Number
Content Type
User Guide
Publication ID
English (United States)
Last Update

The database administrator and application developer can use Database Object Use Count to capture the number of times an application refers to an object.

Database Object Use Count captures counts for the following:

  • Databases
  • Tables
  • Columns
  • Indexes
  • Views
  • Macros
  • Teradata Database stored procedures
  • Triggers
  • User-defined functions
  • Object use access information is not counted for EXPLAIN, INSERT EXPLAIN, or DUMP EXPLAIN statements.

    Once captured, you can use the information to identify possibly obsolete or unused database objects, particularly those that occupy significant quantities of valuable disk space. Further, Database Object Use Count information can be useful to database query analysis tools like Teradata Index Wizard.


    For more information on…


    Teradata Visual Explain

    Teradata Visual Explain User Guide

    Teradata System Emulation Tool

    Teradata System Emulation Tool User Guide

    Teradata Index Wizard, including support for Partitioned Primary Index

  • Teradata Index Wizard User Guide
  • SQL Request and Transaction Processing
  • SQL Data Definition Language
  • Query Capture Database

  • SQL Data Definition Language
  • SQL Request and Transaction Processing
  • Database Query Log

  • Database Administration
  • Data Dictionary
  • SQL Data Definition Language
  • Target Level Emulation

  • SQL Request and Transaction Processing
  • Teradata System Emulation Tool User Guide
  • Database Object Use Count

    Database Administration