With an index for data segment &1, the view could be optimized

Message type: E = Error

Message class: XW - DART - Data Retention Tool

Message number: 244

Message text: With an index for data segment &1, the view could be optimized



What causes this issue?

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


System Response

Not applicable.


How to fix this error?

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


Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.


Error message extract from SAP system. Copyright SAP SE.