Background documentation Deletes/Updates Locate the document in its SAP Library structure

Delete selectivity <percentage>%: <number of> deletes, <number of> rows read, <number of> rows qualified

Update selectivity <percentage>%: <number of> updates, <number of> rows read, <number of> rows qualified

Explanation

The ratio of read rows to modified rows is poor for DELETE or UPDATE statements.

Before UPDATE and DELETE statements can modify or delete rows, the row must be localized in the table. The same access strategies are used as in a SELECT statement.

User Response

Find the statement that causes this poor ratio of read rows to found rows, and check the access strategies for this statement.

Note

For information on creating optimized SQL statements, see Structure linkOptimizer: SAP DB 7.4..