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