15.00 - Defining Join Indexes on UDT Columns and Expressions - Teradata Database

Teradata Database Design

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

Defining Join Indexes on UDT Columns and Expressions

You can define join indexes on the following UDT columns and expressions in the select list and in single-table conditions in the WHERE and ON clauses.

  • UDT columns, including using a method that is associated with a UDT column
  • The following types of expressions.
  • Non-aggregate expressions
  • Non-OLAP expressions
  • Non-UDF expressions
  • This general support for UDT columns and expressions enables you to specify Period data type columns and BEGIN, END and P_INTERSECT expressions on a Period data type in the select list, WHERE clause, and ON clause of a join index definition.