O'Reilly logo

Teradata for Executives by Leslie Nolander, 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 – How Teradata is Designed

“Design is not just what it looks like and feels like. Design is how it works.”- Steve Jobs

Teradata is Designed Around the Primary Index

CREATE TABLE Employee_Table

( Employee_No

INTEGER

 ,Dept_No

INTEGER

 ,First_Name

VARCHAR (12)

 ,Last_Name

CHAR(20)

 ,Salary

DECIMAL (10,2)

) UNIQUE PRIMARY INDEX (Employee_No);

The Primary Index is defined when a table is created. Choosing the best column is by far the most important decision about the table design that you will make.

The three things to know about real estate are location, location and location. The five things to know about Teradata are: Primary Index, Primary Index, Primary Index, Primary Index and Primary Index. Most executives tend ...

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