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) |
| 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 |