Teradata Database Message 9683 - 17.10 - 9683 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
The DBQL ObjectUsage logging is not enabled. The change percentage to skip statistics collection is determined based on dynamic AMP sampling, which can only detect the row count change.
Explanation
The DBQL ObjectUsage logging is not enabled. The change percentage to skip this statistics collection is determined based on the dynamic AMP sampling which can only detect the row count change. Therefore, the system cannot accurately determine the update and the combination of insert and delete counts on the target table.
Generated By
OPD modules.
For Whom
End User.
Notes
This warning is issued when the DBQL ObjectUsage logging is not enabled and statistics collection is skipped.
Remedy
Turn on ObjectUsage logging for the target database if more accuracy is needed.