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
- Stored procedures
- Triggers
- User-defined functions
Object use access information is not counted for EXPLAIN, INSERT EXPLAIN, or DUMP EXPLAIN statements.
You can use count information as follows:
- To identify obsolete or unused database objects, especially those using large amounts of disk space.
- With database query analysis tools.