Thank you all for your valuable inputs. It was great learning.

I rebuild all the indexes of these tables. could still see fragementaion more then 20 - 25 % for all these tables which was rebuild. We have not done any insert oe update / deleteactivities , why is this so?

Is this something related to filesystem fragmentation?