GL Balances archive and purge
Hi,
We performed the gl balances archive and purge recently and we are facing few issues related to GL_BALANCES queries performance exactly after Balances purge happened. And I checked in database about table size, it shows actual size and allocated size differently even after GL_BALANCES export/truncate/import. After export, do we have to drop GL_BALANCES table instead of truncate?
more interesting point is after export/truncate/import.. table allocated size increased than before.. how come this possible? Is there any other way to achieve the performance back?? please suggest
-- before export
allocated = 46279216kb
actual = 36223635.6kb
We performed the gl balances archive and purge recently and we are facing few issues related to GL_BALANCES queries performance exactly after Balances purge happened. And I checked in database about table size, it shows actual size and allocated size differently even after GL_BALANCES export/truncate/import. After export, do we have to drop GL_BALANCES table instead of truncate?
more interesting point is after export/truncate/import.. table allocated size increased than before.. how come this possible? Is there any other way to achieve the performance back?? please suggest
-- before export
allocated = 46279216kb
actual = 36223635.6kb
0