XW244 - La vue pourrait être optimisée avec un index pour le segment de donn. &1.

SAP Error Message - Details

• Message type: E = Error

• Message class: XW - DART - Data Retention Tool

• Message number: 244

• Message text: La vue pourrait être optimisée avec un index pour le segment de donn. &1.

Quelle est la cause de ce problème?

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</>.

Réponse du système

Not applicable.

Comment corriger cette erreur?

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 </>.

Procédure pour les administrateurs système

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

Extrait du message d'erreur du système SAP. Copyright SAP SE.