Archives of the TeradataForum

Message Posted: Fri, 13 Aug 2010 @ 13:48:57 GMT

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

Hi,

Because that's the way Teradata indexing works.

Teradata indexes are (by default) stored by hashing ALL the columns defined to the index. In order to find that index entry (certainly if it's a PI) the DBMS needs to have values for all of the columns in the index, so that it can create the correct hash value. Therefore, in your code you MUST provide an equality constraint on ALL columns in the PI.

Regards,

Dave

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

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