what is mean by NO CONFIDENCE in teradata
In the Explain plan of query:
The size of Spool 1 is estimated with no confidence to be 2,430,428 rows
You can have a look at the documentation in SQL Request and Transaction Processing.
From the doc