17.05 - CHECKSUM - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

A table-specific disk I/O integrity checksum for detection of hardware read errors. The checksum level setting applies to primary data rows, fallback data rows, and all secondary index rows for the table.

For a system-defined join index, the integrity checking setting you specify for a base table also applies to any system-defined join indexes defined on that table. You cannot specify integrity checking for a system-defined join index directly.

If you do not specify a value, the system assumes the system-wide default value for this table type. This is equivalent to specifying DEFAULT.

ON
Calculate checksums using the entire disk block. Sample 100% of the disk blocks to generate a checksum.
OFF
Disables checksum disk I/O integrity checks.
DEFAULT
The default setting is the current DBS Control checksum setting specified for this table type.