Hey thanks for the valid suggestions,

But I can say here the Data statistics here...

In 2011 -----> 1.5Crores rows for each 5 tables

In 2012 -----> 2.5Crores rows for each 5 tables

In 2013 -----> 0.5Crores rows for each 5 tables

just three years data only... we committed with customer that we should not clean the history for the corresponding periods... Coz our audit starts only from the 2011 onwards...