Chapter 34 – Creating Tables, Secondary Indexes, and Join Indexes

“Create a definite plan for carrying out your desire and begin at once, whether you are ready or not, to put this plan into action.”

-Napoleon Hill

Creating a Table with a Unique Primary Index

images

 

 

This is a basic TABLE CREATE STATEMENT. You have Columns and the data types in them. As you see, the Primary Index is defined for a Table at TABLE CREATE time.

Creating a Table with a Non-Unique Primary Index

images

 

 

 

A Non-Unique Primary Index (NUPI) is on the above table. Notice how ...

Get Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.