How to defragment column store table in SAP HANA database

[Soul_star]

Hi Everyone,

How can we perform defragmentation of the column store table?

Need to reorganize the space.

Please let me know, thanks in advance.

Regards,

Shruti 

[Edrilan_Berisha · Accepted solution]

Hi,

have you had a look at the SAP Note: SAP Note 1813245 - SAP HANA DB: Row Store reorganization describes how to determine fragmentation and perform a table redistribution 

https://me.sap.com/notes/1813245

Best,

Edrilan Berisha

[Soul_star · Accepted solution]

Hi Edrilan, thanks for the update. 1813245 this note is for row store reorganization; is any specific note is there for column store reorganization

[Soul_star · Accepted solution]

Can we reorganization/defragment the column store table in hana database?

[mamartins]

No, you can't!  Why? Because you don't need to!

Column store tables are by definition always organized and sorted! That's why SAP HANA achieves those impressive compression ratios.

[Soul_star]

Thanks for the info!