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.