|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/22/2008 6:22:09 AM
Posts: 2,
Visits: 29
|
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 5/20/2008 5:21:02 AM
Posts: 28,
Visits: 20
|
|
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
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/22/2008 6:22:09 AM
Posts: 2,
Visits: 29
|
|
|
|
|