>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!