Posted by Rory McKinley on 09/26/05 10:34

Rory Browne wrote:
<snip>deleting an index(a good index that
> is) would slow the db down in certain cases. Deleting a "bad index"
> would speed certain operations up.
<snip>


If the index in question happens to be a unique index or a primary key
(really just a special case of index) - you could be breaking the logic
of the table (allowing duplicates where there should be none).

Pretty much as Rory (the other one) said: An index makes write
operations slower and read operations faster. When you are doing bulk
inserts to a table it is often a good idea to drop any index , populate
the table and then re-index (for performance reasons).

Regards

Rory

[Back to original message]