Tech Interview Questions site organizes over 1000 tech interview questions from multiple job functions. All these are in an easy question and answer format.
Teradata Indexes
The Optimal Teradata Index is a NUPI with a USI
-----------------------------------
Selection of Primary Index
PI Column set should provide good data distribution, join efficiencies and fequently used access path
-----------------------------------
Single-AMP A one-AMP or Single-AMP request uses the row hash to determine which AMP contains the requested rows.An example of a single-AMP request is primary index retrieval
Multi-AMP A Multi-AMP request may use two or more AMPs. Examples of two-AMP requests are unique secondary index retrieval and a row inserted to a fallback protected table.
All-AMP When the requested data resides on any AMP, then an all-AMP request is required to obtain it. Examples of all-AMP requests are full-table scans, some joins and all retrivals based on non-unique secondary indexes
-----------------------------------
Partners
News & Event