All Forums Database
lijianguonew 5 posts Joined 07/14
04 Aug 2014
what is mean by NO CONFIDENCE in teradata

Hello Experts:
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

Raja_KT 1246 posts Joined 07/09
04 Aug 2014

You can have a look at the documentation in SQL Request and Transaction Processing.

Good read:


Confidence Levels For Single Table Retrieval Operations, Confidence Levels For Join Operations.
From the doc

The system has neither Low nor High confidence in the cardinality and distinct value estimates for the relation.

The Optimizer pursues  conservative strategies to optimize the relevant steps. Reason  with example given from the doc: Any of the following situations exists:

• There are no statistics on the column or index sets 

specified in the predicate.

• The predicate contains complex expressions for 

which statistics cannot be collected.

For example, statistics cannot be collected for

either of the following two expressions:

• SUBSTR(col1,5,10)


WHEN x=10 THEN x+10

ELSE x-10

• For an aggregate estimation, there are no statistics

on the grouping columns.



Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

lijianguonew 5 posts Joined 07/14
05 Aug 2014

Thanks Raja

You must sign in to leave a comment.