No Primary Index (NoPI) Table in TD 13

Database
Enthusiast

No Primary Index (NoPI) Table in TD 13

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
REATE 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;

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
1. How to resolve the skew factor issue with the help of NoPI in TD 13?

2. Can we resolve this skew factor issue with the help of NoPI in TD 13?

Any ideas or suggestions please.

Thank You,
Tags (1)