Current Perm Vs Skew Factor

Database
Enthusiast

Current Perm Vs Skew Factor

Hi Friends,

Is current perm of a table is inversely proportional to Skew factor [SF] ?

I had a table [WFLOW_RUN] with 93% skew factor. Hence have changed its PI, and copied data to have better distribution.. The SF has been reduced, but the current perm has been increased 2 times... but both have same rows..

TableName                   CurrentPerm                      PeakPerm                SkewFactor

-------------------------------------------------------------------------------------------------------

WFLOW_RUN               712,704                             712,704                             93

WFLOW_RUN11        1,544,192                          1,544,192                             21

2 REPLIES
Enthusiast

Re: Current Perm Vs Skew Factor

Any comments on this ?

Junior Contributor

Re: Current Perm Vs Skew Factor

What's the number of rows and the number of AMPs in your system?

Nobody cares about skew for a small table like this...

Check if the 2nd table is defined with FALLBACK