15.00 - Restrictions on Secondary Index Definitions - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Restrictions on Secondary Index Definitions

You cannot define unique secondary indexes on a join index.

You can define the primary index of a join index to be row partitioned if and only if the join index is not also defined with row compression. See the documentation for CREATE JOIN INDEX in SQL Data Definition Language for more information about specifying partitioned primary indexes for join indexes.