2896028 - DB6: Slow performance of BW processing with BW temporary tables since conversion to BLU

After the conversion to BLU, you notice the performance slowness in BW processing, like query processing or master data load.
From the application snapshot, you see the problematic query is using BW temporary table with row-organized.

Please check SAP Note 1139396-Temporary database objects in BW 7.X for the possible BW temporary tables.

### Case Study ###
During the master data load, the following SQL is causing the performance issue:

UPDATE "/BI0/S<infoobject>" SET "ABC" = ? WHERE "SID" IN ( SELECT "/BI0/0600000123"."SID" FROM "/BI0/0600000123" ) WITH CS

And /BI0/S<infoobject> is column-organized while the temporary BW table /BI0/0600000123 is row-organized.

You can use the following SQL to check if table is column-organized or row-organized:
select varchar(tabname, 35), tableorg, create_time from syscat.tables where tabname like '<table name>';

Check tableorg column:
C=column-organized, R=row-organized

SAP on IBM Db2 for Linux, UNIX, and Windows

DB2 BLU Acceleration, column-organized tables, row-organized temporary tables, DB6_TMP_USE_CDE, /BI0/06, /BI0/0P , KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , Problem