dw size

gistfile1.txt

select count(*) as payr_dtl from dw.paYR_DTL; -- 171,280,225
select count(*) from dw.remitDTL;             --392,726,040
select count(*) from dw.frght_bl;             --408,302,966
select count(*) from dw.exceptions;           -- 201,285,497
select count(*) from dw.invoice;              -- 598,03,644
select count(*) from dw.fb_ln;                --1,226,455,963
select count(*) from dw.frghtBlMaster;        --686,564,991
select count(*) from dw.ca_ELEM;              --554,904,231
select count(*) from dw.veNDOR_REMIT;         --9697
select count(*) from dw.veNDOR;               --8379
select count(*) from dw.inv_bat;              --32,460,110
select count(*) from dw.checktable;           --1,215,235
select count(*) from dw.freightBillAudit      --58,072,344;