Database

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

08-04-2014
05:59 PM

08-04-2014
05:59 PM

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

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

08-04-2014
08:21 PM

08-04-2014
08:21 PM

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)

• CASE

WHEN x=10 THEN x+10

ELSE x-10

• For an aggregate estimation, there are no statistics

on the grouping columns.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

08-05-2014
05:20 PM

08-05-2014
05:20 PM

Thanks Raja