Thanks for your reply. There are around 10 tables out of 90+ tables that gets used frequently, out of which 3 tables have 3+Million rows with data size averaging 500MB....