15.00 - QITS Column - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Programming Reference

QITS Column

The first column defined for any queue table must be a Queue Insertion TimeStamp (QITS) column. Each queue table has only 1 QITS column, and it must be defined exactly as indicated with the following attributes.


where QITS_column_name indicates the name you specify for the QITS column.

The precision specification is optional for the TIMESTAMP data type specification and its DEFAULT attribute, but you cannot define either with a precision value other than 6.

The QITS column is user‑, not system‑defined; however, the only significant option you have when defining the QITS column is its name.

A QITS column cannot be defined as any of the following.

  • Unique secondary index
  • Identity column
  • A QITS column can be the NUPI for a table, but you should avoid following that practice. If you do not define an explicit primary index, primary key, or uniquely constrained column in the table, the QITS column becomes its primary index by default because it is the first column defined for the table.

    You should select the primary index column set that best optimizes the performance of browse mode select operations on the table, just as you would for a non‑queue table.

    You might find it useful to define additional queue management columns for functions such as message identification or queue sequencing for your queue tables. See the CREATE TABLE (Queue Table Form) “Example 4” topic in SQL Data Definition Language for an example of creating a queue table that uses an identity column to generate a queue sequence number (QSN) for each row.