Hi,
I know if we are not creating and loading table with out proper primary index, will be getting skew ness in AMPS. But i head that even if we create a table with proper primary index, but if it has less number of records (less than no of AMPS available), then also it will create the Skew ness. As per my idea it will not create.
 

 
Hi,
Can anyone please provide some clue about the reason for the following performance issues.
1) 

What is the skewness of a stored procedure in Teradata?
I am getting the Skew factor close to 100 (~99) for SPs in Teradata.
 The database only contains SPs.Is it that SPs are stored AMP local and cannot be distributed across AMPs like a tables dat?