Solution : https://service.sap.com/sap/support/notes/334224 (Connexion à SAP Service Marketplace requise)
Résumé :
This SAP Note discusses the importance of creating database indexes to improve system performance. The note outlines the reasons for requiring indexes due to costly database statements and the steps for creating these indexes in SAP systems. Index creation should start in the development environment followed by a test in the quality assurance environment, before moving it to production. Special attention is given to table operations during index creation, suggesting performance implications related to table size. For larger tables, index creation should occur during periods of low activity or downtime. Factors like parallel processing, use of specific database tools, and updating of cost optimizer statistics post-index creation are also highlighted to ensure efficient implementation.
Mots Clés :
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>
Notes associées :
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 |