Archives of the TeradataForum
Message Posted: Fri, 12 Jan 2007 @ 14:27:48 GMT
To your query one i.e.: 96% skew. Perhaps you can proceed in the below manner:
1) have your second column which is unique for even distribution as your primary index. This will help reduce the skew and hence gain back space.
2) have a secondary index on ur current PI column which is used in your query joins.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|