i have a query which is running slow so i've been adding index's to various fields to test to see if i can find any improvements.
i have a problem though as a program runs and instead of updating values deletes a record the by the id field and then re-adds with the new values (yes stupid i know).
what i've noticed is that there is an index on that field set to 'create as clustered'.
I've always avoided the clustered index as i've heard its a bad option, but am wondering that if this value is being deleted and re-created and is set to the clustered mode if this might be a problem?
View Complete Post