Table 15 describes the 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. |