Teradata Visual Explain uses derived-table icons. A derived table is a spool in the visual plan.
|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.|