cluster index and update and delete
We have a performance issue for a large database. I plan to place a cluster index to a key table which involved a lot of update and delete activity. I want to know if cluster index will slow down the update and delete activities. What is the best way to do that? any other alternative?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, it has currently non-clustered index(es) in place over the same columns. What's your other suggestion?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I wonder if dropping the original non-cluster index will cause problem for the application?
It will if you don't have the clustered index in place first.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You should capture and save all existing index stats as well as the missing index stats before changing the indexes, otherwise the current info will be lost.
You should also review that info to verify that you are creating the clustered index with the correct column(s).
You should also review that info to verify that you are creating the clustered index with the correct column(s).
ASKER