This question already has an answer here:
Hi I have a SQL Stored Proc that used to take 45 seconds to execute.
Then I run the
Execution Plan under SQL and saw some high cost steps:
Then I right click that and select:
And finally I create the indexes that the
Execution Plan recommend me.
Now the Query takes 2 seconds that is acceptable.
Is that right what I did? Does it come with extra cost?
Any advice is well appreciated