Archives of the TeradataForum

Message Posted: Tue, 09 Sep 2003 @ 06:28:32 GMT

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

Hash Indexes have ROWID included in them always by default. We do not have an option to prevent inclusion of ROWID in a Hash Index. In case we explicitly specify ROWID in a Hash Index definition, TD ignores the redundancy as it would have already incorporated ROWID in the definition.

This feature of Hash Index to implicitly include ROWID is what distinguishes it from a single table Join Index.

But ROWID need to be explicitly specified for inclusion in case of a Join Index.

Sanjaya

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