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:
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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.