Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Long running SQL
Have a look at this URL :
http://www.jlcomp.demon.co.uk/faq/duplicates.html
It gives details on how to best detect duplicate rows in a table. At the end is a couple of scripts, one of which runs for hours, the other, doing the same thing, runs in seconds.
It worked for me !
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.comReceived on Thu Oct 03 2002 - 12:11:38 CDT
-------------------------------------