 |
 |
Archives of the TeradataForum
Message Posted: Wed, 25 Jul 2007 @ 10:59:41 GMT
| Subj: | | Re: Collecting statistics and 'no confidence' |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, July 25, 2007 01:13 -->
Victor Sokovin wrote:
| | Is it possible to post table definitions and the explain plan of the query? | |
| | If not, then I'll just make one guess: t1.c1=t2.c1 might require an implicit data type conversion if data types of t1.c1 and t2.c1 are
different. | |
Hi,
Because of security reasons I cannot provide the table definitions, Statistics are collected regularly on the tables participating in the join
operation and the join columns participating in the query of same data type, but when explain statement is collected Teradata still shows "size of
the spool is estimated with low confidence", I appreciate any guesses on this.
Regards,
Anom.
| |
