Archives of the TeradataForum

Message Posted: Tue, 21 Feb 2006 @ 23:50:29 GMT

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

<-- Anonymously Posted: Tuesday, February 21, 2006 17:12 -->

If one has to have a Primary Index access, then one has to specify equality conditions on all columns of primary index. The hash value is computed from all the columns of primary index.

In your specific case it does all-rows scan. If an index is defined on this column, we may have scope for that index access path.

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