Solution : https://service.sap.com/sap/support/notes/334224 (SAP Service marketplace login required)
Summary :
Key words :
sql server configuration parameter max degree, sap db/maxdb creates indexes, practically avoids negative impact, sql server management studio, sql server configuration setting, database specific acceleration possibilites, db2 command line processor, abap data dictionary globally, sql server books online, command create index <index_name>
Related Notes :
| 1489410 | Performance Optimization in Managed Systems |
| 912620 | FAQ: Oracle indexes |
| 869521 | Oracle <= 10g: TM locks with REBUILD ONLINE / CREATE ONLINE |
| 806554 | FAQ: I/O-intensive database operations |
| 650584 | Poor performance payment order selection for account |
| 548100 | IS-H CH: Sekundärindex für Tabelle NWCH70 |
| 538394 | IS-H EDI performance file upload program (RNC301I0) |
| 532744 | Q&A: Master Note for U.S. Third-Party Remittance |
| 521751 | Q&A: Master Note for Canadian Third-Party Remittance |
| 483562 | Expensive SQL Statement on /SAPAPO/TRQTAH or /SAPAPO/V_TRQTA |
| 416729 | Performance for archiving / collective processing of orders |
| 387649 | Expensive SQL statement on table SOFFPHIO |
| 365744 | Expensive SQL Statement on VIQMEL or VIAUFK |
| 365054 | Expensive statement on view CAUFV |
| 350893 | Expensive SQL Statement on table VLKPA |
| 339690 | High response time of RIBELF00 |
| 338760 | Expensive statement on table PLOGI |
| 337633 | Expensive SQL Statement on Table COBRB |
| 336760 | Expensive SQL Statement on Table VSSTEU |