Expect the following effects, depending on the value set for CHECKSUM:
- Setting CHECKSUM=1 helps ensure data integrity during RESTORE, but this might cause a slight performance drop due to the fact that the checksum value for the data blocks is calculated only by the Teradata Database.
- Setting CHECKSUM=2 provides verification of data integrity during both ARCHIVE and RESTORE, but because both the Teradata Database and Teradata ARC calculate the checksum, this can result in a significant performance drop.