Archives of the TeradataForum

Message Posted: Thu, 17 May 2012 @ 10:29:20 GMT

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

Hi,

"Order by Hash" is the default for an index (as noted in the manuals :-) ).

The alternative is "order by values" which sorts the index rows by the data value.

If you are using the index column in an equality constraint then there will not be any difference. If the index is used in a range constraint then the value ordered index can be faster.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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