Teradata Indexes

Your Ad Here

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