Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 18:30:24 GMT

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

Whoops misread your original question. I did not see the word ROWS. I also thought you wanted all the duplicate rows gone; not keeping one row for each value (don't know why anyone would want to remove all duplicate rows anyhow; leaving only row that id not have duplicate values.).

This means your table is a MULTISET table. Only true solution is to create a new SET table. And insert into it from the old table. Then drop and rename tables. This solution will also prevent it from happening in the future.

If you don't have enough space, you will have to fastexport the data. Drop the table then create the SET table and fastload it.

Don't forget to take the opportunity to add PPI and column compression. Also set appropriate freespace (this can be done on existing tables).

Thanks,

Bob Diehl

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