1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Quick Tip to Enhance BW Query Performance

Tuesday, 31 July 2012 13:56

Written by Prakash Palani

Print E-mail

Quick tip to enhance BW Query Performance

If  you get a complaint from end user that an SAP BW Query is performing awfully low, the first step to be taken is that you must try to understand the expensive average response time component. If the analysis reveals that the performance is low due to  inefficient execution plan caused by obsolete update statistics, then it is recommended to update the statistics for the infocube using RSRV transaction.  As an additional measure, you can instruct BW support team to introduce the process type “Construct Database Statistics” (under Data target administration) in the process chain itself, the same should be added right after data is loaded and index is created on the infocube.

 

 {fcomment} {flike}

Share

Quick Tip to Enhance BW Query Performance