O'Reilly logo

Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition by Tom Coffing, William 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 8 – Columnar Tables

“I am desperately trying to figure out why Kamikaze pilots wore helmets.”

– Dave Edison

Columnar Tables have NO Primary Index

CREATE Table Employee_NoPI
(
  Emp_No       Integer
 ,Dept_No      Integer
 ,First_Name   Varchar(20)
 ,Last_Name    Char(20)
 ,Salary       Decimal (10,2)
)
No Primary Index ;
This table is called a No Primary Index (NoPI) Table!

 

Before discussing how to CREATE a Columnar table, it is important that you understand that Teradata allows for NOPI tables which distinctly state NO Primary Index.

This is NOT a NoPI Table

CREATE Table Employee_NoPI
(
 Emp_No Integer
 ,Dept_No          Integer
 ,First_Name       Varchar(20)
 ,Last_Name        Char(20)
 ,Salary           Decimal (10,2)
) ;
This table is NOT a No Primary Index (NoPI) Table! This ...

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