>Somewhere recently I saw posted an idea for a quick identification of duplicate records in an indexed table, but I cannot find it with UT search. Anyone remember it?
>
>regards,
Try this...
SELECT fieldname, COUNT (*) AS ct FROM tablename GROUP BY fieldname HAVING ct>1
fieldname is the indexed field
tablename is the table
I did this on two and a half million records and it found eleven duplicates in just eight minutes!