Thank you Jeff Moden for your reply.

I have compared the indexes on the database(which was restored by using a backup before the modifications).

The index structures are same on...