Thank you all for your responses. As of Now, I have given scripts for rebuilding indexes. Yet to implement this.