Hi,
When I am creating the index on 1 table of the sp, it is executing faster. after creating the Index, when I just alter the same sp with no any other changes in the code, that sp is taking time and execution plan is being chnaged.
Aaing if i am Drop & creating the same index, sp executing fatser but after again alter it is performing slow.
What can be reason of change the execution plan only after alter sp even no any code change is there.
Please suggest.