Ansicht
Dokumentation

05128 - Creating indexes to improve performance...

05128 - Creating indexes to improve performance...

Fill RESBD Structure from EBP Component Structure   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.
SAP E-Book

Creating indexes to improve performance...

Hello,

I would agree with your ABAP programers, especially where commonly used
tables are concerned. Have you looked in SAPNet yet for the possibility of
any relevant notes? Are you current with EarlyWatch Express? As you can see,
there may be other options.

You can also create a SAPNet message if you own searches prove to be
fruitless.

Hope this helps,
Murray

-----Original Message-----
From: desmond_olwageZg...
[mailto:desmond_olwageZg...]
Sent: Tuesday, February 19, 2002 2:09 AM
To: sap400Zm...
Subject: Creating indexes to improve performance...


Hi, guys.

I have seen several messages regarding the creation of an index to improve
runtime. The example was improving runtime from 30 minutes to 10 seconds by
creating an index.

I approached our ABAP programmers with this info and their reaction was
that they are hesitant to create indexes because of other performance
problems that they might be creating. For example, they could create an
index on the billing table(s) to improve runtime on queries done there, but
that, by doing so, they may increase the runtime on the actual billing
process (system having to update in more places). Is this the case? Can
anyone enlighten me here please?

Thanks.

Des Olwage
Snr. Systems Administrator
Goodyear South Africa
Tel. +27 41 5055441
Cell. +27 82 824 6900


Durban Tours - Südafrika Safari

BAL_S_LOG - Application Log: Log header data   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 2254 Date: 20240221 Time: 192114     sap01-206 ( 3 ms )