cancel
Showing results for 
Search instead for 
Did you mean: 

How to defragment column store table in SAP HANA database

Soul_star
Explorer
0 Kudos
150

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 

View Entire Topic
mamartins
Active Contributor
0 Kudos

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
Explorer
0 Kudos
Thanks for the info!