15.00 - Object Identifier Columns - Teradata Database

Teradata Database Design

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

Object Identifier Columns

For each BLOB, CLOB, or XML column created for a table, Teradata Database automatically stores a 40‑byte or 45‑byte multiple field pointer in the row to the subtable that stores the actual BLOB, CLOB, or XML data for that column (see “Sizing a LOB or XML Subtable” on page 861). This value, referred to as an OID, is stored in VARBYTE format.

If a BLOB, CLOB, or XML column is null, then so is its OID.

The column sizes reported here are for OIDs stored on disk in rows. They do not include, and are not the same as, the sizes of OIDs passed as inline or deferred host parameters as part of a USING request modifier row.