15.00 - CREATE FUNCTION and Multi-Value Compression of UDT Columns - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

CREATE FUNCTION and Multi‑Value Compression of UDT Columns

You can use multi‑value compression only for distinct UDTs based on the following predefined data types.

  • All numeric types.
  • DATE
  • CHARACTER and CHARACTER SET GRAPHIC
  • VARCHAR and CHARACTER SET VARGRAPHIC
  • BYTE
  • VARBYTE
  • You can specify the compression attributes COMPRESS NULL and NO COMPRESS for the following UDT data types:

  • Distinct and structured types that are not based on BLOB or CLOB types
  • ARRAY and VARRAY types
  • Period types