Is it possible to reorganize database like the Oracle Reorg?

Hello,

I have a question regarding reorganization database.
Is it possible to reorganize database like the Oracle Reorg?
( https://docs.oracle.com/cd/B10501_01/em.920/a86647/reorg.htm )

Thanks

Hi haj,

No we don’t have such a tool. There i less maintaince involved in maintaining MemSQLs on-disk data.

  • Rowstore snapshots and logs are maintaince free. rowstore indexes are not stored directly on disk (they are rebuilt in-memory on start-up) so disk fragementation issues are avoided entirely for rowstore.
  • Columnstore blobs are stored on disk and are maintained by the background merger (which can be assisted by fore ground mergers via OPTIMIZE TABLE https://docs.memsql.com/sql-reference/v6.8/optimize-table/). Its job is the compact blobs that have deleted rows and merger small blobs into larger blobs. Outside of large write operations you generally don’t need to manually run OPTIMIZE TABLE.
2 Likes