Archives of the TeradataForum

Message Posted: Fri, 04 Sep 2009 @ 19:46:19 GMT

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

I was spending some time in the manual and found the sort key limit we were discussing two months ago here on the Forum:

"The BYNET only looks at the first 4 096 bytes of the sort key created to sort the specified fields, so if the field the sort key is based on is greater than 4 096 bytes, the key is truncated and the data might or might not come back in the desired order."

The manual was for V2R5, not the releases mentioned by the OP (Trevor Price), but I guess it is still the same limit of 4 096 bytes on the combined sort key.

If ordering in ORDER BY or DISTINCT stops working on fields of combined length less than this limit then it's a bug, otherwise - a documented feature.

Probably not a well known feature as we would seldom sort on such long fields to notice it.

Victor

Admin Comment: This thread began with:

www.teradataforum.com/teradata/20090709_163603.htm

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