All Forums Database
sk8s3i 35 posts Joined 06/13
12 Nov 2014
Skew Factor of small tables

Hi,
 
I have a table with 75 rows. The table is defined as MULTISET table with UNIQUE PRIMARY INDEX.
When I calculated the skew factor, it came close to 77.
 
If the table is created with UPI, this must ensure that the data is distributed evenly accross AMPs. What could be the possible reason for this high skew factor?
 
Any help is appreciated.
 
Regards,
Shardul.

-Thanks Shardul

Dixxie 58 posts Joined 12/10
18 Nov 2014

Hi Shardul,
The rows always are distributed on the AMPs by the hash of the columns selected for the Primary Index.
This is so regardless the table is SET or MULTISET.
Regards.
 

Glass 225 posts Joined 04/10
18 Nov 2014

How many Amps?

ToddAWalter 316 posts Joined 10/11
18 Nov 2014

See answers in:
http://forums.teradata.com/forum/database/how-to-reduce-skew-factor-on-stage-tables-with-nopi

You must sign in to leave a comment.