Archives of the TeradataForum

Message Posted: Mon, 16 Feb 2004 @ 19:30:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Today I got the following message when selecting from a very large table. The number of rows shown is about 24% less than the actual cardinality of the table. Message 6813 does not appear in the manual. Any ideas what it all means? We are on:

RELEASE V2R.04.01.03.40
VERSION 04.01.03.98

select *
 from [large_table]
;

 *** Query completed. 4294967295 rows found. 27 columns returned.
 *** Warning: 6813
 *** Total elapsed time was 38 minutes and 49 seconds.

	<Prev	Next>		<<First	<Prev	Next>	Last>>