Online Tutorials & Training Materials |
Register Login

Difference between Online and Offline Row Store Reorganization

02 Aug 2017 11:43 am || 0

Online vs. Offline Row Store Reorganization

The row store can be reorganized online or offline.

The following overview provides a comparison of both approaches:


Offline reorganization

Online reorganization


SAP HANA database is completely unavailable

Currently reorganized table is blocked against changes (transactional object lock)
Read operations to all tables and modifications of other SAP HANA tables are still possible

Restart required

Yes (reorganization happens during restart)



Maximum defragmentation

Significant, but not always maximum defragmentation

Memory footprint

Optimal memory footprint

Increased memory footprint in case of concurrent changes or open transactions



Increased in case of resource or object lock contention