Hi,

I want to find out if there are duplicate records in a table.

For example:
There is a table with e-mailaddresses. I want to see which e-mailaddresses appears in more than one record.

I know I can create an action in which I loop through the records, performing an action event for each record, which creates a collection of all records with that e-mailaddress.          

However, this is very inefficient when record numbers grow (will  be far over 100.000)

Is there another way to take this on?