Friday, 10 August 2012

Which statement is true about a primary index operation? | Teradata

A. The degree of uniqueness is not critical to efficiency.
B. When choosing a primary index you should pick a column with a severely limited value set.
C. If distribution is skewed an all-AMP operation will take longer than if all AMPs were evenly utilized.
D. Selecting a NUPI for storing data provides for maximum efficiency and makes the best  use of the parallel  features of Teradata.

ANS: C

No comments: