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

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
stb1559324757649.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
Teradata Vantage

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.