Vantage Features that Do Not Support Join Indexes - Teradata VantageCloud Lake

Lake - Database Reference
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

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