Specifying the INDEXES keyword increases the time and media required for an archive. This option does not apply to journal table archives. The option is ignored for cluster and specific AMP archives.
The INDEXES keyword usually causes Teradata ARC to archive unique and non-unique secondary indexes on all data tables. However, if an AMP is offline, Teradata ARC only archives unique secondary indexes on fallback tables. Therefore, for the INDEXES keyword to be most effective, do not use it when AMPs are offline.
If the archive applies a group read HUT lock, Teradata ARC writes no indexes to the archive file.