Archives of the TeradataForum

Message Posted: Tue, 23 Feb 2010 @ 13:04:15 GMT

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

Arul Joseph Daniel wrote:

Just explain it.

It's a Full Table Scan.

Of course those 4 values might be hashed, but there are 4,294,967,292 other hash values, thus any index access would be useless.

Dieter

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