Thanks for ur reply.

Yes i am doing this on production db.

i tried doing it first from mangment studio, it gave me time out so i generated sql script but it...

Thanks for all replies

Sometimes the first index is used and other times the other one, when i removed on of them on backup of life database, i found that the queries using the...

Thanks very much for all replies.

They were very informative

I appreciate ur reply.

I found this by Coincidence, i was looking for duplicate indexes, then this came out.

Before i delete it i wanted to make sure its not used anywhere...

Thanks for ur reply,

The table size is about 400 mb.

based on ur reply i think sql server used the clustered index seek becuase the fields were not included in index...