Unique Secondary Indexes - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
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.