Posted by Michael Evanchik on 10/21/07 04:10

Im trying to dedupe a table with only one field on it. The table has
40 million records in it. What is the fastest way?

1) create a table with a unque constraint on it insert into that
table?

2) create a table without a unique constraint on it and use insert
into table select distinct un from table2?

3) another way?

Michael

• Next in forum: database to comprehensively manage anniversaries
• Prev in forum: ¿Libros en español para Diseño de Base de datos y Normalización?
• Thread view: fastest way to deduplicate a list

[Reply to this message]