Archives of the TeradataForum

Message Posted: Tue, 10 Oct 2006 @ 22:28:07 GMT

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

<-- Anonymously Posted: Tuesday, October 10, 2006 18:18 -->

Never noticed this, but order of columns in INDEX specification logically doesn't matter.

And in fact it won't physically differ either since assigned sequence in the index, i.e. DBC.Indexes.FieldPosition, will actually depend on FieldID and not the order in the DDL.

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