Display Icons - Visual Explain

Teradata Visual Explain User Guide

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

Icons are used in Teradata Visual Explain to visually depict the execution plan. The various icons provide information on:

  • The type of statement executed
  • The type of join used
  • The eligibility of a table or spool for synchronized scanning
  • Whether the table or spool is cached
  • The method of retrieval (for example, single‑AMP retrieval, multi‑AMP retrieval or all‑AMP retrieval)
  • The distribution of rows (for example, whether the rows were locally built, duplicated on all AMPs or redistributed on all AMPs)
  • End transaction information
  • For icon descriptions, see:

  • Statement Icons
  • Retrieval‑Method Icons
  • Data‑Redistribution‑Method Icons
  • Table and Spool Icons
  • Derived‑Table Icons
  • Index Icons
  • Aggregate‑Step Icons
  • Join‑Method Icons
  • Other Operation Icons
  • Error Icon
  • Note: Tool Tips and Pop‑Up Menus provide additional information about each icon.