Retrieval-Method Icons - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Retrieval‑Method Icons

Table 13 describes the retrieval‑method icons.

 

Table 13: Retrieval‑Method Icons 

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.