Archives of the TeradataForum

Message Posted: Tue, 07 Nov 2006 @ 23:05:47 GMT

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

Hi Terry,

I don't think there's any advantage to having both a hash and value ordered NUSI on the same column.

If a query specifies "WHERE date-column = value" then either type of column will allow the indexed access. So what's the reason for having both?

Cheers,

Dave

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

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