16.20 - Creating a Join Index With an XML Type - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1140-162K

When the inline length is equal to the maximum length, the XML type is treated as a nonLOB type. In this case, the nonLOB XML type can be part of a join index. However, it cannot be part of the primary index of the join index.