Vantage Features that Do Not Support Join Indexes - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The following table summarizes the Vantage features that do not support join indexes.

Feature Reason Not Supported Recommended Workaround
Permanent journal recovery Recovery process does not rebuild join indexes. Rebuild join indexes after the permanent journal recovery completes.
MultiLoad Utilities do not maintain join indexes.
  1. Make sure that no queries are running against tables that use the join index to be dropped.
  2. Drop join indexes before loading or restoring the base tables.
  3. Recreate join indexes after loading or restoring the base tables.
FastLoad
Teradata Parallel Transporter LOAD and UPDATE operators