SAP Knowledge Base Article - Preview

2934465 - Slow query performance using Factviews - SAP BW on ASE

Symptom

  • Infocube activation or certain DTP loads are slow on SAP BW systems running on SAP ASE database
  • A slow query is identified either via t-code RSRT in DEBUG mode OR in isql via sp_monitor 'connection' or sp_w and sp_sp outputs.

The query references Factviews in the PLAN clause - for example:

PLAN ' (use optgoal sap_olap)
(use fact_table (table /BIC/FCCOPA2 (in (view F))))
(use fact_table (table /BIC/ECCOPA2 (in (view F))))
(use parallel 4)
(prop (table /BIC/ECCOPA2 (in (view F))) (parallel 4))
(prop (table /BIC/FCCOPA2 (in (view F))) (parallel 4)) '

  • SE38 -> RSSYBDBVERSION report indicates all GREEN lights (ie. BW Correction Collection is applied and the ASE configuration is as required per Best Practices)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Warehouse (BW)
  • SAP Netweaver (NW) all versions

Product

SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

slow, performance, Factviews, Factview, factview, 701, 722 , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

About this page

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

Search for additional results

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