15.00 - Restrictions on the Data Type of Hash 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 Hash Index Columns

You cannot include columns with the following data types in a hash index definition:

  • XML
  • BLOB
  • CLOB
  • BLOB‑based UDTs
  • CLOB‑based UDTs
  • XML‑based UDTs
  • ARRAY
  • VARRAY
  • Period
  • Geospatial
  • JSON