0 - 7 of 7 tags for indexes
How know if an index is used?
By mybudy, 23 Sep 2013 | Tagged: index indexes indexv | 8 comments
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? 

By TeradataMaddy, 11 Mar 2013 | Tagged: indexes
Partitioned Primary Indexes (PPI): Getting Started

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

By DebraH, 25 Feb 2013 | Tagged: primary index indexes aji ppi secondary index partitioned primary index | 12 comments
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.

By DebraH, 06 Apr 2011 | Tagged: primary index indexes aji ppi secondary index | 3 comments
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

By Carmine001, 29 Apr 2010 | Tagged: indexes | 12 comments
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?

By carrie, 14 Dec 2009 | Tagged: database indexes secondary indexes tpump nusi | 2 comments
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.

By Alison, 20 Apr 2009 | Tagged: indexes primary indexes secondary indexes join indexes hash indexes partitioned primary indexes v_database | 19 comments