2528751 - DB6: BW Query performance after attribute change | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2528751 - DB6: BW Query performance after attribute change

Symptom

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' ))))))
...


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.