Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 17:59:17 GMT

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

Create a "SET" table and then make an "insert into select"

This will ignore dupes, but you will end up with a "SET" table. You may copy this to a "MULTISET" table again.

This is to avoid "group by"'s, etc. in your query. They are more or less done internally.

I am sure, that it is faster, to do the group by in your query.

Christian

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