How To Fix XW244 - Mit einem Index für das Datensegment &1 könnte der View optimiert werden

SAP Error Message - Details

• Message type: E = Error

• Message class: XW - DART - Data Retention Tool

• Message number: 244

• Message text: Mit einem Index für das Datensegment &1 könnte der View optimiert werden

Was verursacht dieses Problem?

None of the attributes of the join conditions that link the segments
were found in an index for data segment &V1&. The view query could be
optimized by creating an index for this data segment using one of the
join fields. When an index is not present, the data is located via a
data segment scan.
For large data segments, an index could improve the performance of the
query. To aid in the efficiency of the index, it is recommended that
the most discriminating field be chosen. For small data segments, such
as small master data segments, an index is not necessary or
advantageous. A data segment scan through a small number of records is
sufficiently efficient. Thus, it does not warrant the overhead cost of
the creation of an index. The data set size for the segment should be
used as the determining factor: an index aided query for large data
sets, a data segment scan for small data sets.
A related topic is the <DS:DE.TXW_QBUFMX>Maximum Buffer Query size</>.

Systemantwort

Not applicable.

Wie behebe ich diesen Fehler?

In the configuration, set up an index on data segment &V1& using one of
the fields listed in the join conditions. Reminder: Using the most
discriminating field has the greatest benefit.
The path is <DS:TRAN.FTWQ>Configuration -> Data_segments</>. In change
mode, select the data segment &V1&. In the pop-up dialog box, enter in
the 'Index fields' area the chosen field for the join condition. This
will configure an index on the segment &V1& using the chosen field for
future or rebuilt extractions.
To rebuild an extract which will re-configure the segments using the
new index, choose the path is <DS:TRAN.FTWM>Utilities -> Rebuild data
file </>.

Vorgehensweise für Systemadministratoren

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE