Archives of the TeradataForum

Message Posted: Tue, 24 Jul 2001 @ 15:58:23 GMT

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

Shelly,

The data conversion is definitely what is impacting you here. The system must do a full table scan and convert the character values to numeric to compare them.

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