O'Reilly logo

Teradata Database Administration – The Fundamentals by Thomas Coffing, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3 – The Primary Index is the Axis of all Teradata Systems

“If I have seen farther than others, it is because I was standing on the shoulders of giants.”

- Isaac Newton

The Primary Index is defined when the table is CREATED

images

The Primary Index is defined when the table is CREATED. Above, we have a UPI which stands for a Unique Primary Index (UPI).

A Unique Primary Index (UPI)

 

CREATE TABLE Emp_Intl

(Emp_NoDept_NoFirst_NameLast_NameSalary  INTEGER,SMALLINT,VARCHAR(12),CHAR(20),DECIMAL(10,2))

UNIQUE Primary Index ( Emp_No)

images

A Unique ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required