Steve I cannot tell you if this is still true, but in an earlier version of R:Base (I beleive 6.x DOS) in an application where we needed to delete a chunk of rows from table that had a LOT of indexed columns, it was actually faster to DROP the indexes (except the one needed in the WHERE clause for the DELETE command), delete the rows and rebuild the indexes, than it was to KEEP all the indexes and delete the rows.
Is your situation like this? David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Steve Breen" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, April 26, 2005 5:05 PM Subject: [RBASE-L] - Re: Deleting row question > How would you speed up the process? > > -----Original Message----- > From: A. Razzak Memon [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 26, 2005 4:08 PM > To: [email protected] > Subject: [RBASE-L] - Re: Deleting row question > > > At 04:58 PM 4/26/2005, you wrote: > > >Do index's affect the speed of deleting rows from a table? > > Steve, > > Only when you use with the WHERE clause on the INDEXed Column(s). > > Very Best R:egards, > > Razzak. > > >
