InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 20:06:39 GMT20http://www.teradata.com/teradataforum/Topic10715-1-1.aspxThanksThu, 28 Feb 2008 01:40:53 GMTppurnimahttp://www.teradata.com/teradataforum/Topic10715-1-1.aspxWhen 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 valuesWed, 27 Feb 2008 06:39:17 GMTfoxbathttp://www.teradata.com/teradataforum/Topic10715-1-1.aspxWhat is a HOT AMPWed, 27 Feb 2008 04:22:58 GMTppurnima