2528751 - DB6: BW Query performance after attribute change

Some queries on BW tables become slow after attribute change.

No data volume change on BW tables and the same queries run quickly with same data volume before.

Autorunstats of database has been turned on and run correctly like following:

AUTO_MAINT=ON
AUTO_RUNSTATS=ON
AUTO_STMT_STATS=ON
AUTO_TBL_MAINT=ON

The SQL Statement of BW query looks like following:

SELECT "T1"."VENDOR" AS "K____2317",
            "T1"."/BIC/ZRT_STTC" AS "K____2342",
            "T2"."CM_CDT3" AS "K____2350",
            "T1"."MATERIAL" AS "K____2238",
            "T2"."CM_CDT1" AS "K____2345",
            "T2"."CM_HIEID" AS "K____2346",
            "T2"."RF_SKU" AS "K____2347",
            "T1"."LOC_CURRCY" AS "K____2262",
            "T1"."CURRENCY" AS "K____2331",
            SUM ("T1"."/BIC/ZXXXXXX1") AS "Z____4051",
            SUM ("T1"."/BIC/ZXXXXXX2") AS "Z____4052",
            SUM ("T1"."/BIC/ZXXXXXX3") AS "Z____4053",
            SUM ("T1"."/BIC/ZXXXXXX4") AS "Z____4054",
            SUM ("T1"."/BIC/ZXXXXXX5") AS "Z____4055",
            SUM ("T1"."/BIC/ZXXXXXX6") AS "Z____4056",
            SUM ("T1"."/BIC/ZXXXXXXP") AS "Z____2372",
            SUM ("T1"."/BIC/ZXXXXXXP") AS "Z____2373",
            SUM ("T1"."/BIC/ZXXXXXXP") AS "Z____2374",
...

FROM "<BW_Table1>" "T1"
JOIN "<BW_Table2>" "T2" ON "T1" . "MATERIAL" = "T2" . "MATERIAL"
JOIN "<BW_Table3>" "T3" ON "T2" . "MATERIAL" = "T3" . "MATERIAL"
WHERE (((((("T1"."VENDOR" = '0000007312' ))))
        AND (((("T1"."/BIC/ZRT_STTC" IN (' ',
                                         '01',
                                         '02',
                                         '11',
                                         'C1',
                                         'R1',
                                         'S1',
                                         'Z1',
                                         'Z2') ))))
        AND (((("T2"."CM_CDT3" = '10207' ))))))
...

SAP on IBM Db2 for Linux, UNIX, and Windows

Performance, BW query, Slow, Attribute Change, RUNSTATS ON TABLE, DB6 , KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , Problem