SAP Knowledge Base Article - Preview

1912678 - Long runtime when updating where-used list

Symptom

Creating / changing table maintenance dialogues using transaction SE11 / SE55 takes long (up to several minutes). Tracing that action using transaction ST05 or ST12 / SE30 reveals that most of the time is spent by selecting against table WBCROSSGT. Creating a HANA performance trace according to SAP note 1787489 shows the following:

perftrace_kba.png

These SELECT statements are repeated a large number of times with durations of a few seconds. This is the exact statement text:

SELECT "OTYPE" , "NAME" , "INCLUDE" , "DIRECT" , "INDIRECT" , "COMPONENT" FROM "WBCROSSGT" WHERE "INCLUDE" = ?

Read more...

Environment

  • SAP HANA Database
  • Netweaver 7.4 on HANA

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0 ; SAP NetWeaver 7.4

Keywords

column store; row store; , KBA , HAN-DB , SAP HANA Database , BC-DWB-UTL , Workbench Utilities , 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.