Sometimes the huge/Bulk DML operation leads to Index performance degration.... to overcome this type of issues, we suppose to either reorganize/rebuild the indexes periodically....
First get the Index fragmentation percent of each index,
If fragmentation percent is >= 5 and <30 then we will go ahead with REORGANIZATION of that index....
ALTER INDEX ALL
ON TableName REORGANIZE
It reorganizes the leaf nodes of the index physically