>>What is the best method to identify duplicate records in a table?
>>In this case there is approx 1.5 million records and i need to look at
>>each field.
>>
>>your help will be appreciated.
>
>I dont know if this is the best way, but I programmatically check my tables for duplicate records (meaning all fields the same in more than 1 record) with SELECT DISTINCT * FROM MYTABLE into MYARRAY and compare RECCOUNT() OF original table to _TALLY. If _TALLY is less then I ZAP original table and APPEND FROM MYARRAY. HTH

Could you try to Select ~1.5 million records to array?