I need to add a new extra field at the end of the order on the existing non-cluster index to impove the performance of a SP. This index already has two fields there.
After I add the new extra field at the end of the order, it help me to improve the performance of a SP by 50%.
Now, I want to ask will it slow any other existing SPs performance which use that table or that index. I understand that if I add the new field at the end, it should not affect anything except it will a bit slow on insertion on that table.
Any comment of this!!