>>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!
Wow! Thanks for the tip. I'll put it in my good snippits box right now.
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.
