Archives of the TeradataForum

Message Posted: Thu, 12 Aug 2010 @ 14:35:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Thank you for the reply.

My actual table is below.

     CREATE MULTISET TABLE NZL.200 ,NO FALLBACK ,
           C2O DECIMAL(1,0),
           C2PS_POUND DECIMAL(6,0),
           C2R DECIMAL(1,0),
           C2S DECIMAL(1,0),
           C2SAL DECIMAL(3,0),
           C2STS CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           C2TYP CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           COR DECIMAL(1,0),
           CUSNO DECIMAL(6,0),
           HOUSE CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
           ORDNPO DECIMAL(6,0),
           PRDNQO CHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC,
           QUANCO DECIMAL(11,0),
           QUANS DECIMAL(11,0),
           UNITM CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
           C2OY DECIMAL(2,0),
           C2ON DECIMAL(2,0),
           C2OR DECIMAL(2,0),
           C2RY DECIMAL(2,0),
           C2RN DECIMAL(2,0),
           C2RR DECIMAL(2,0),
           C2SSY DECIMAL(2,0),
           C2SDN DECIMAL(2,0),
           C2STR DECIMAL(2,0),
           CORMY DECIMAL(2,0),
           CORCN DECIMAL(2,0),
           CORRR DECIMAL(2,0))
     NO PRIMARY INDEX;

This table skewed with 98.6%.

How to resolve the skew factor issue with the help of NoPI in TD 13?

Thank you,

Naveen

	<Prev	Next>		<<First	<Prev	Next>	Last>>