15.00 - Table Definition - Teradata Database

Teradata Database Design

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

Table Definition

The table used in this demonstration is a simple three-column customer table, defined as follows.

 

   Column Name

           Attribute Described

      Type of Index Defined on the Column

Cust

Customer Number

USI

Name

Customer Last Name

NUSI

Phone

Customer Phone Number

NUPI

The following is a snapshot instance of this table.

 

Base table and secondary index subtable rows are distributed as illustrated by the following graphic.