Thursday, January 27, 2011

Does Primary Index column choosing is important?

The Success of teradata warehouse starts with choosing of correct column
to create primary index on that.....

Try to Choose a column which has unique values. so that data can be distributed evenly among
all AMPs ..... Otherwise Skewness will come into picture. and also primary index is useful to get a straight path to retrieve data

No comments:

Post a Comment