!--a11y-->
Records Selected from the Database 
Technical name: 0TCTNDBSEL
Use
The Records Selected from the Database key figure (0TCTNDBSEL) counts the records that are read to the database with a query in order to calculate the result.
The number of records that are selected from the database are different from the number of records that are transferred from the database (see
Records Transferred from the Database) if the data is grouped together and read: In this case, several records are grouped together for a resulting record. Therefore, the number of records selected from the database needs to be greater than or equal to the number of records that are transferred from the database.From the ratio between the key figures Records Selected from the Database and Records Transferred from the Database (or from the ratio of the respective fields for the table RSDDSTAT, namely QDBSEL and QDBTRANS), you can determine whether it would be useful to use an aggregate: The larget the QDBSEL/QDBTRANS quotient is, the more helpful an aggregate would be, as long as the time needed for the database is significant (see
Time, Reading from the Database).Technical Data
|
Available as of Release |
2.0/02 |
|
Unit |
No |
|
Aggregation |
SUM |
|
Exception Aggregation |
Summation |
|
Calculation |
No |
|
Restriction |
No |