We need help on the table reorg?
if we have 10 mil rows in a table and the size is 4G.
We purge the table deleting about 200000 rows from the table every
weekend.
Then after 3 months it has about seven mill rows.
After six months it has 4 mill rows. T
The table size is still 4gb.
Is this due to fragmentation?
When should I do reorg for this table after two months ,four, when?
by doing purge we mean "delete". after deleting rows from a table how will size go down?
Then after 3 months it has about seven mill rows.
After six months it has 4 mill rows. T
The table size is still 4gb.
Is this due to fragmentation?
When should I do reorg for this table after two months ,four, when?
by doing purge we mean "delete". after deleting rows from a table how will size go down?
0