![]() |
23 Sep 2013
| 8 comments
,
|
![]() |
Hi,
11 Mar 2013
,
|
![]() |
This session provides information on the basic concepts of Partitioned Primary Indexes.
25 Feb 2013
| 12 comments
,
|
![]() |
This is more than an overview of the Indexes that are available in Teradata and how they work.
06 Apr 2011
| 3 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
29 Apr 2010
| 12 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?
14 Dec 2009
| 2 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.
20 Apr 2009
| 19 comments
,
|