Unique Secondary Indexes - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

If a table without fallback is restored with AMPs offline, unique secondary indexes defined for the table are invalidated. This prevents future updates to the table until the unique secondary indexes are regenerated. Drop and recreate them or use the BUILD statement.