Re: How to find Duplicate records

Frank,

>> "SQL> create table new_test nologging
>> 2 as (select /* +APPEND */ distinct * from test);

looks like a typo to me :o( - I suspect Oracle treats it as a comment. I can't imagine what I had been drinking/sniffing/injecting when I wrote that in SQL*Plus !
I'll update the faq page and send it to Jonathan - thanks.

As for the index bit, I suspect you are correct - I'll have to give it a try. I stopped trying to make (my own procedures which merge data from two tables in two different databases into one, then delete the duplicates) more efficient when the biggest table had its deletions done in 30 seconds rather than 45+ minutes. My system now works in total in half an hour, while the original (Supplied by a product supplier) took over 4 hours !

Regards,
Norman.

(This is what happens when you have to do your own proof reading !)

Norman Dunbar		EMail:	NDunbar_at_LynxFinancialSystems.co.uk
Database/Unix administrator	Phone:	0113 289 6265
Lynx Financial Systems Ltd.	Fax:	0113 201 7265
			URL:	http://www.LynxFinancialSystems.com
------------------------------------------------------------------------