Page 1 of 1

duplicate records

Posted: Fri Mar 26, 2004 11:13 am
by MiniMe
When I build an index as unique I get about 100 or duplicate records. I want to remove the dupes. Is there any way to remove the ones that were not indexed or do I have to drop the index, delete the dupes and re-index.? the total database is about 38million rows.