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

The USI Subtable contains two columns:

1. Emp_No (The USI column)

2. Row-ID of the real Primary Index of the base table

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

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