Ansicht
Dokumentation

05157 - Record deletion and index performance?

05157 - Record deletion and index performance?

BAL Application Log Documentation   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

Record deletion and index performance?

Thanks for the responses.

From the answers that I got on the first one, regarding the index fragmentation,
it sounds as I suspected: deleted entries won't hurt, but I won't get any
performance improvements on access times until I reorganize.

I didn't make my second question very clear. I'm already using RGZPFM, but I
wasn't sure how it worked. From the responses that I received on my example, if
I have a 100GB file that has 50GB of deleted records, I'll need 50GB, plus a bit
of overhead, to reorganize the file. I won't need the full 100GB of free space
to reorganize it.

Thanks again!

Jim Doll, Perrigo


Durban Tours - Südafrika Safari

PERFORM Short Reference   General Material Data  
This documentation is copyright by SAP AG.

Length: 1063 Date: 20240302 Time: 135244     sap01-206 ( 3 ms )