Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Compress Indexes

I have using the dba cockpit to enable the compression of the "Biggest table" of the SAP Bank Analyzer ( reducing the table from 360GB to 100GB ). This OFFLINE process took 23 hours.

Please , advise us how to the compress also the INDEXES of the tables.

Former Member
Former Member replied

Hello Mr. Arun,

Thanks for contacting us.

Kindly use the below command to enable the compression on a particular table. But before enabling the compression, make sure that you have executed query given in note 886231 to make sure whether compression is required for this table or not.

ALTER TABLE <tabname> ACTIVATE VALUE COMPRESSION

Kindly refer below note

#1942183 - DB6: When to consider a table or index reorganization

#975352 - DB6: Configuring DB2 Auto Reorg for Space Reclamation and Index Cleanup

Hope the above information helps!

Best Regards,
Gunjan

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question