|
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
Navigation:
[Reply to this message]
|