O'Reilly logo

Teradata Architecture for IT and Developers by Tom Coffing, John Nolan

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

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