Skip to end of metadata
Go to start of metadata

Use

Deletes selectivity <percentage>%: <number_of> deletes, <number_of> rows read, <number_of> rows qualified

Updates 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 UPDATE or DELETE statements.

Before UPDATE and DELETE statements can modify or delete rows, the rows must be located 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 the SQL Optimizer documentation.

 

More Information

Relevant  DB-Analyzer Files
Helpful with ...
DBAN_LOAD.csvAccesses and selectivity of SELECT, FETCH, INSERT, UPDATE, and DELETE statements
DBAN_RUNNING_COMMANDS.prt List of SQL statements that were active when starting Database Analyzer analysis. 
SAP Note
Helpful with ...
  
Expert Sessions (Link to trainings)
Content / Helpful with ...

Session 16: SAP MaxDB SQL Query Optimization (Part 1)
Session 16: SAP MaxDB SQL Query Optimization (Part 2)

Find detailed information about different optimizer strategies and performance optimization.
Documentation (links)
Helpful with ...
SQL Optimizer <übernommen>
  • No labels