Query Performance Improvement Tools

[Former Member]

Hi BW Guru's

What are the Query Performance improvement tools , If you want make to useful than, what is activity you need to perform.

Cheers,

Bhima Chandra Sekhar G

[Former Member]

The BW Performance Tuning Knowledge Center site on SDN is good too.

https://www.sdn.sap.com/sdn/developerareas/bi.sdn?page=bi_performance.htm

Basic tuning -

Ignoring the issue of modeling and query design, these are the basic tools to start with.

Here's the order I would tackle things -

Compression

InfoCube Aggregates

Additional Indexes - on ODS, Dim and Master Data tables

Additional indexes require an understanding of how the queries are run and to ability to understand SQL execution plans.

[Former Member]

Hi,

You might want to refer to this link -->

https://websmp101.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=DISPL_TXT&_NNUM=0567746&;

Look at the following thread -->>

and also the OSS note 557870 on query performance. Hope it helps.

Cheers,

Sree

[Former Member]

Also check the BI Performance tuning sections given below.

https://websmp101.sap-ag.de/~sapidb/011000358700008300682002E/performance_tuning.htm