0 - 7 of 7 tags for indexes

   I am new to Teradata and self-learning Teradata . The manuals says many things about UPI,USI,NUSI.
 If a table has one PI,two or thre NUSI's , how is the data stored on AMP's? Is there any order of preference to consider PI and NUSI's of  a table? 

This session will provide information on the basic concepts of Partitioned Primary Indexes.

This is more than an overview of the Indexes that are available in Teradata and how they work.


I´m new on Teradata i´m have a doubt on how Teradata works whith the index.

If i have a Primary Index whith 4 columns, if i make a sql with a where with 3 of this columns, Teradata use the index or not? and if i make a sql whith a where with the 4 columns and one more, Teradara use the index?


Suppose you have a table with several non-unique secondary indexes (NUSI). When TPump loads the table, should you expect that each row’s INSERT will cause a table level lock on each of the secondary index sub-tables? And if so, couldn’t this create a lot of blocking across sessions?

Some of you may be familiar with relational databases other than Teradata and how those other RDBMs utilize indexes.

In Teradata, an “Index” is a physical mechanism that is used to distribute, store, and access data rows. Indexes provide a physical access path to the data and their use can avoid unnecessary full-table scans to locate rows.