15.00 - Archive and Recovery - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Archive and Recovery

You cannot use the Teradata Archive/Recovery utility to archive or restore hash and join indexes, though archiving is supported for a base table or database that has associated hash or join indexes defined on it.

Before you can restore such a base table or database, you must drop the hash and join indexes that are associated with it, and then recreate the dropped indexes after the recovery operation completes. Otherwise, the Optimizer cannot use those indexes for a query plan.

See Teradata Archive/Recovery Utility Reference for details.