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:
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" = ?|
- SAP HANA Database
- Netweaver 7.4 on HANA
column store; row store; , KBA , HAN-DB , SAP HANA Database , BC-DWB-UTL , Workbench Utilities , Problem
About this pageThis 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.