Join and Hash Indexes | Teradata Vantage - 17.00 - 17.05 - Join and Hash Indexes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Node Software Migration Guide

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
Configuration
Installation
featnum
B035-5942-170K

DSA manages to save and rebuild all join and hash indexes as part of the archive and restore operations.

DSA performs join and hash index maintenance during the post-script phase of a restoration job, and statistics maintenance during the dictionary phase. As long as the restoration reaches the data phase of restoration, statistics information is not lost if the job subsequently fails.