Derived-Table 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

Teradata Visual Explain uses derived‑table icons. A derived table is a spool in the visual plan.

Table 16 describes the derived‑table icons.

 

Table 16: Derived‑Table Icons 

Icon

Object

Definition

Derived table

Information from a table, which is stored in the spool.

Derived table with high confidence

A derived table with high confidence level.

Derived table with low confidence

A derived table with low confidence level.

Derived table index join confidence

A derived table index with join confidence.

The label “JC” indicates that the number of rows is estimated with index join confidence.

Derived table with no confidence

A derived table with no confidence level.