All Forums UDA
ppurnima 2 posts Joined 02/08
27 Feb 2008
What is a HOT AMP

What is a HOT AMP

foxbat 27 posts Joined 06/07
27 Feb 2008

When the workload is not distributed across all the AMPs, only a few AMPs end up overburdened with the work. This is a hot AMP condition.This typically occurs when the volume of data you are dealing with is high and (a). You are trying to retrieve the data in a TERADATA table which is not well distributed across the AMPs on the system (bad Primary Index) OR(b). When you are trying to join on column with highly non unique values OR(c). When you apply the DISTINCT operator on a column with highly non unique values

ppurnima 2 posts Joined 02/08
28 Feb 2008

Thanks

You must sign in to leave a comment.