Chapter 11 - Secondary Indexes

“People can have the Model T in any color – so long as it's black.”

- Henry Ford

Creating a Unique Secondary Index (USI)

images

We created a Unique Secondary Index (USI) on the column Emp_No named idxname.

What is in a Unique Secondary Index (USI) Subtable?

images

Inside the secondary index subtable is the column Emp_No (USI Column). Then, there is the corresponding Row-ID of the real Primary Index of the table. The USI subtable's Primary Index is Emp_No, and it is hashed and has a Row-ID like a normal table.

A Unique Secondary ...

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.