Archives of the TeradataForum

Message Posted: Thu, 12 Aug 2010 @ 13:30:22 GMT

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

Hi,

We do have lot of tables with skew factor up to 98%.

We were thinking of using NoPI i.e. allowing a table with no primary index acting as a staging table, data can be loaded into the table a lot more efficiently and in turn faster.

We do have a table

     CREATE MULTISET TABLE NZL.200 ,NO FALLBACK ,
          (SMN DECIMAL(2,0),
           RYR DECIMAL(2,0))
     PRIMARY INDEX ( SMN );

The skew factor for the above table is 98.6%.

We change the above table to the below one with NoPI, the skew factor is same.

     CREATE MULTISET TABLE NZL.TBD_AUG_12_200 AS (SELECT * FROM NZL.200)
        WITH NO DATA
        NO PRIMARY INDEX;

As per the td pdf it says "If the source table is skewed or the resulting spool is skewed, the target NoPI table can also be skewed.

Question

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

Any ideas or suggestions please.

Regards,

Naveen

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