> "Aage Johansen" <aagjohan@...> wrote in message
>> Dropping indexes (or de-activing them) might make a difference.
On Tue, 17 Jun 2003 20:22:47 +0000 (UTC), Don Gollahon wrote:
> I have refrained from that. It might speed up the deletes but the database
> is so big (up to 6 GB) that it would probably take just as long a time to
> rebuild the indices and so I wouldn't gain anything.
You are (most probably) right. But if you have indexes with _many_
duplicate values the delete may be quite slow because of the work involved
in tracking down the correct entry (among all the duplicates). YMMV - if
your selectivity is good: don't bother.