Effects on Performance - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Effects on Performance

Because a rollback can conceivably involve millions or even billions of rows, a rollback can affect the performance and availability of resources in Teradata Database while the rollback is in progress.

The rollback affects the performance of the system because the rollback competes for CPU with other users. Moreover, a rollback can keep locks on affected tables for hours, or even for days, until the rollback is complete.