An all-AMPs restore of a complete database from an archive of a complete database:
- Drops all objects in the resident version of the database. Join and hash indexes created prior to Teradata Tools and Utilities 13.00.00 are also dropped. See Join and Hash Indexes in Restoring for information on join and hash indexes in Teradata Tools and Utilities 13.00.00 and later.
- Restores all objects in the archive. For a complete list of objects supported by Teradata ARC, see Database Objects.