According to the manual "DELETE DUPLICATES processes faster when the table contains an indexed column and the USING collist option is used" I have used this command without any problems on indexed columns. Make sure that you have the correct setting for NULL and CASE.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jim Limburg Sent: Tuesday, August 27, 2002 10:53 AM To: [EMAIL PROTECTED] Subject: Re: Delete Duplicates Bernard I believe you have to drop indexes on the table you are working with to get the delete dup to work Hope this helps.. And don't do like I did last year and forget to re-apply the index Jim Limburg --- Bernard Lis <[EMAIL PROTECTED]> wrote: > Using 6.5++ win 1.855 > > delete duplicates from poheader using ponum > > gives me: 0 rows deleted > > There are 21 duplicate rows > > Bernie Lis > Megabytes, Inc. > __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
