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 ...

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.