I have created one index sometime that includes one column (non primary) and the other column as Included column. It was working good. But later after 2 weeks I started seeing some time outs from the procedure again. While Investigation and to check further I added another index covering both the columns. So currently I have two indexes :
1. One column and other as included
2. Two columns as covering index. Initially this index had one column, I just added the other column which was included to other index
TEchnically are not both the indexes same?
I am little hesitant to delete either of the one as after creating the covering indexes the time out is stopped.
Please suggest with your opinion.