Skip to Content
0

RSZWOBJ: Conversion of Row to Column Store

Jun 12, 2017 at 04:30 PM

42

avatar image
Former Member

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?

Thanks

Abhishek Shanbhogue

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers