| Icon | Method | Circumstances When Used |
|---|---|---|
|
All-AMP Retrieve | The data resides on more than two AMPs. |
|
Multi AMP Retrieve | Teradata Database uses various hashing combinations. |
|
Single AMP Retrieve | Teradata Database can use the row hash to determine which AMP contains the requested row. |
|
Two AMP Retrieve | Teradata Database uses various hashing combinations. |