Re: deletes and indexes

On 27 Jan 2005 04:39:46 -0800, johnleslie_at_madasafish.com (John Leslie) wrote:

>Do indexes speed up deletes?
>
>I am deleting 100000 rows from a table containing 1 million rows and
>it seems faster without the index. The index is created on the column
>used in the delete where clause.
>
>I created the index specifically to speed up the delete, but is my
>thinking incorrect?

Your thinking is indeed incorrect. Whenever a row is inserted, updated, or deleted, all of the indexes on that table have to be maintained as well, to account for the change. Thanks.

• Ed Stevens

Cohn's Law: The more time you spend in reporting on what you are doing, the less time you have to do anything. Stability is achieved when you spend all your time doing nothing but reporting on the nothing you are doing. Received on Thu Jan 27 2005 - 07:20:05 CST