Re: How to find Duplicate records

Thanks to Frank for taking the trouble to supply some feedback; and to Norman
for updating the FAQ as a consequence.

Remember - no FAQ page should be
considered complete: if you have further useful suggestions, alternative techniques, special cases etc. they can be added.

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html

Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.




Norman Dunbar wrote in message
<48B95088F03ED511BE5A00508BEED0881ED1F5_at_tapps.leeds.lfs.co.uk>...


>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

>------------------------------------------------------------------------

>--------

>