- Unique secondary (USI)
- Nonunique secondary (NUSI)
- Hash-ordered secondary
- Value-ordered secondary
- Single-table simple join
- Single-table aggregate join
The default, indicated by not specifying this clause in your INITIATE INDEX ANALYSIS request, is to include all valid index types for consideration by the analysis. The list of valid index types for index analysis does not include multitable join indexes.
For example, you may join indexes from consideration by the analysis, which you consider undesirable for workloads that invoke utilities such as Teradata MultiLoad, which cannot be run against tables that have join indexes defined on them. For more information about restrictions and interactions with tables on which join indexes are defined, see CREATE JOIN INDEX and When Join Indexes Are Useful .
You can substitute Teradata FastLoad for Teradata MultiLoad to batch load rows into an empty staging table and then use an INSERT ... SELECT request with error logging or a MERGE request with error logging to move the rows into their target table. See INSERT/INSERT ... SELECT, MERGE, and CREATE ERROR TABLE.