How know if an index is used?
,
23 Sep 2013
| 8 comments
Storing of rows on AMPS based on UPI,NUSI,USI
,
11 Mar 2013
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
,
25 Feb 2013
| 12 comments
This session provides information on the basic concepts of Partitioned Primary Indexes.
Teradata Indexes – How They Work & When to Use Them
,
06 Apr 2011
| 3 comments
This is more than an overview of the Indexes that are available in Teradata and how they work.
Use of a Primary Index
,
29 Apr 2010
| 12 comments
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
,
14 Dec 2009
| 2 comments
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?
Indexes, Too Much of a Good Thing?
,
20 Apr 2009
| 19 comments
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.