Tags for secondary indexes
Implimenting Seconday indexes
We have 8 Tables  in 3rd normal form conatining demographic information about an organization. We want to join this data to  data sets containing transactional data generated by the organizaiton. 
secondary indexes
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