Ahh, but we might remember... <g> Regards, Alastair. ----- Original Message ----- From: Emmitt Dove To: RBASE-L Mailing List Sent: Thursday, August 06, 2009 11:58 PM Subject: [RBASE-L] - RE: Deleting dups
No, Doug, cannot go there. I suspect the R:BASE doc has had many, many hands in it, but a couple of very discerning overlords. Actually, come to think of it, Razzak did ask me to write the doc on some feature I requested. Don't for the life of me remember what it was. (But I bet *he* does .) Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Doug Hamilton Sent: Thursday, August 06, 2009 5:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Deleting dups Read it? I thought you wrote it! D Emmitt Dove wrote: Got me there, Paul. Guess I should read the doc more often! Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Paul InterlockInfo Sent: Thursday, August 06, 2009 4:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Deleting dups About the DELETE DUPLICATES Command Use DELETE DUPLICATES to delete duplicate rows from a table. A duplicate row is a row where the values for each column are exactly the same as those in another row in the table. This command deletes all but the first row for each set of duplicate rows. DELETE DUPLICATES processes faster when the table contains an indexed column and the USING collist option is used. Rules for Column Deletion And I thought line "DELETE DUPLICATES processes faster when the table contains an indexed column and the USING collist option is used." Was right. Sincerely, Paul D. From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Thursday, August 06, 2009 3:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Deleting dups AFAIK, DELETE DUPLICATES will not use indexes. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, August 06, 2009 3:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Deleting dups I'm sure I can test this but I'm lazy ... I need to delete duplicates on a huge table using 2 of the columns. Both of these columns are normally indexed. I'm wondering if I should drop the indexes before I do the delete? I would think that as it deletes the dups it has to update the indexes, which would take longer. On the other hand, does the command actually use the index, thereby making the deletion faster? If no one knows off the top of their head then I'll time both of the methods... Karen ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.392 / Virus Database: 270.13.45/2285 - Release Date: 08/06/09 05:57:00
