O'Reilly logo

Teradata Physical Database Design by Tom Coffing, Leah Nolander

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 5 - Secondary Indexes – An Alternate Path to the Data

“Cowards die many times before their deaths; the valiant never taste of death but once.”

– William Shakespeare

Creating a Unique Secondary Index (USI)

images

A Subtable is created on each AMP anytime a secondary index is created

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

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