Anyone have problems with tables that have the primary key as a composite. Also i have a clustered index on primary key. Seems like i am getting erratic performance on deletes ( < 10,000 rows). I created made the index on the primary key as non-clustered and put a clustered index on another field. Performance seems to be better on the second approach. ( deletes only)Any ideas
As you already done, review the indexes, your delete statement to use correct index by examine the query execution plan. Be aware of changing the indexes may affect other queries to this table and should be tested completely.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply