Table and Spool Icons

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K
Table and Spool Icons 
Icon Object Definition
Table A table involved in the operation.
Table eligible for synchronized scanning (not cached) A table involved in the operation that is eligible for synchronized scanning.
Spool A spool, which is where intermediate query results are stored.
Low Confidence Spool A target spool, where the number of rows is estimated with a low confidence.
High Confidence Spool A target spool, where the number of rows is estimated with a high confidence.
Index Join Confidence Spool A target spool, where the number of rows is estimated with an index join confidence.
No Confidence Spool A target spool, where number of rows is estimated with no confidence, which may indicate lack of collected statistics or certain query constraints.
High Confidence IN-List Spool A spool whose rows are made up from the values of an IN condition. Used to maximize the performance of a special class of star join queries. The confidence is always high because the cardinality is known.