What is a HOT AMP

UDA

What is a HOT AMP

What is a HOT AMP
2 REPLIES
Enthusiast

Re: What is a HOT AMP

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

Re: What is a HOT AMP

Thanks