How will you avoid Skewness?

Questions by muralidharr

Showing Answers 1 - 2 of 2 Answers


  • Feb 1st, 2011

Data or Amp skew occurs in teradata due to uneven distribution of data accross all the amps. Often, this leads to spool space error too. To avoid skewness, try to select a Primary Index which has as many unique values as possible.

PI columns like month, day, etc. will have very few unique values. So during data distribution only a few amps will hold all the data resulting in skew. If a column (or a combination of columns) is chosen a PI which enforces uniqueness on the table, then the data distribution will be even and the data will not be skewed.

  Was this answer useful?  Yes


  • May 25th, 2017

Unequal distribution of data on amps is called skewness. Choose PI columns as unique as possible to avoid this.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions