Tags for indexes
How know if an index is used?
index indexes indexv
Storing of rows on AMPS based on UPI,NUSI,USI
Hi,     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? 
Partitioned Primary Indexes (PPI): Getting Started
This session provides information on the basic concepts of Partitioned Primary Indexes.
primary index indexes aji ppi secondary index partitioned primary index
Teradata Indexes – How They Work & When to Use Them
This is more than an overview of the Indexes that are available in Teradata and how they work.
primary index indexes aji ppi secondary index
Use of a Primary Index
Hello, 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? Thanks
Crossing NUSI Update Contention Off Your Watch List
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?
database indexes secondary indexes tpump nusi
Indexes, Too Much of a Good Thing?
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.
indexes primary indexes secondary indexes join indexes hash indexes partitioned primary indexes v_database