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
