15.00 - Restrictions on the Data Type of Join Index Columns - Teradata Database

Teradata Database Design

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

Restrictions on the Data Type of Join Index Columns

You cannot specify columns having any of the following data types in the definition of a join index:

  • XML columns
  • BLOB columns
  • CLOB columns
  • BLOB‑based UDT columns
  • CLOB‑based UDT columns
  • XML‑based UDT columns
  • ARRAY/VARRAY columns
  • Geospatial columns
  • This also means that a join index cannot have a geospatial NUSI.