As mentioned, out of 50 tables, 10+  tables have 20+ millions records or so.  So obviously, the data volume is high. Since more indexes exists too. Other tables have around...