Archives of the TeradataForum
Message Posted: Thu, 12 Aug 2010 @ 13:30:22 GMT
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.
How to resolve the skew factor issue with the help of NoPI in TD 13?
Any ideas or suggestions please.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|