Database Object Use Count - Teradata Database

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…	See…
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