Archives of the TeradataForum

Message Posted: Wed, 08 Nov 2006 @ 11:27:26 GMT

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

Hi,

Value order is best suited for range queries, as they are sorted by values rather than hash values.

In case of regular NUSI collect stats, and make sure to see the explain plan to confirm its not going for any FTS(Full table scan).

Regards,

Vijay kumar.R

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