Skip to Content
author's profile photo Former Member
Former Member

RSZWOBJ: Conversion of Row to Column Store

Hello All,

Part of optimization exercise when we checked for the tables that are hogging memory, we found RSZWOBJ was the one that occupied the max. Upon assessment we tried to deleted entries from the table but it had least impact.

We are currently on BW 7.4 SP7 & HANA SPS 10.

One of the ideas to reduce the table was to convert the Rowstore table to Column. And I want to know is it OK to convert this standard table and has anyone tried such approach

I found SAP Note 2044047 that suggest that if we upgrade to BW 7.4 SP08 then number of tables with row store will be only 1000 and this might be possibly one of them. They also suggested program: RSDU_MOVE_TO_COLUMN can be used to check for table conversion.

Are there any other ideas to recover space from this table?


Abhishek Shanbhogue

Add comment
10|10000 characters needed characters exceeded

0 Answers