Teradata Indexes

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


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

-----------------------------------

News & Event