Table Delete

Hi,

If I delete rows from a table which contains a non-clustered index, how is the index affected during this process? E.g. Do the remaining index pointers need to be updated to reference rows that have not been deleted etc.

Also does adding an index make a delete operation perform better?

Thanks.

If you're deleting the entire table, the index might end up slowing down the operation.

Indexes are for optimizing searches, it can slow down data manipulation operations though.