Archives of the TeradataForum

Message Posted: Mon, 07 Feb 2011 @ 19:47:43 GMT


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

Subj:		Re: Performance impact of VARCHAR size

From:		Victor Sokovin

For ORDER/GROUP BY any VARCHAR columns are converted to CHAR, so spool space needed for sorting is much larger now.

Sorting can also get a lot less precise when the combined length of the sort columns gets high:

Victor


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

Archives

2011 Indexes

Last Modified: 15 Jun 2023