Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: No Primary Index (NoPI) Table in TD 13
 
From:   Shindhe, Naveen

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023