Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 20:07:08 GMT

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

I don't understand what you mean when you say that "it goes on to recollect on the index".

When talking about a single-column index, then whether the collect statement is performed on the column or on the index, the two statements are effectively the same thing and whichever one you chose, it only needs to be done once.

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