Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

Difference between Online and Offline Row Store Reorganization

|| 0

Difference between Online and Offline Row Store Reorganization
Stechies

Online vs. Offline Row Store Reorganization

The row store can be reorganized online or offline.

The following overview provides a comparison of both approaches:


Aspect

Offline reorganization

Online reorganization

Availability

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)

No

Defragmentation

Maximum defragmentation

Significant, but not always maximum defragmentation

Memory footprint

Optimal memory footprint

Increased memory footprint in case of concurrent changes or open transactions

Runtime

Optimal

Increased in case of resource or object lock contention


Advertisement
Advertisement