Can the access be optimized by creating an additional index?
If the existing selective conditions are not sufficiently supported by an index, a corresponding index can be created for optimization or – if no side effects are possible – an existing index can be modified. For information about the index, see FAQ Note 928037. Note that in the R/3 system, some central tables are accessed using special index tables (Note 185530 for SD, Note 191492 for MM/WM, and Note 187906 for PP/PM). In the cases described, you should open the initial screen using an index table, so that no other index must be created. The same applies for accesses on the table BSEG, for the index tables such as BSIS, BSAS, BSID, and BSAD. Large number of disk reads per execution Together with primary key ranges, a large number of disk reads is often only available using the fields MANDT or Full Table Scans.
Related Questions
- How are the reporting requirements of the partners in a collaborative arrangement to be satisfied without creating additional work?
- Is there a way to prevent primary key, foreign key and unique constraints from creating an index?
- Why is the tunnel the best alternative for creating additional access to the Port?