How it works...

The previous query will return the data distribution of PI, which is Today_DT. As we are loading daily data into this, it will only have one date, and that will be the current date. This means all the rows will be residing on only ONE AMP, which means SKEW:

• HASHROW(): Returns the RowHash number of the column(s)
• HASHBUCKET(): Returns the Hash Bucket number of the column(s)
• HASHAMP(): Returns the AMP that would store/process the column(s)

If you are wondering what these functions stand for.