Ansicht
Dokumentation

SQL4010 - Table scan access for table &1. ( OS/400 )

SQL4010 - Table scan access for table &1. ( OS/400 )

TXBHW - Original Tax Base Amount in Local Currency   General Data in Customer Master  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL4010
Table scan access for table &1.

Message Long Text :

Cause . . . . . : Table scan access was used to select rows from the table. The table number refers to the relative position of this table in the query.
Recovery . . . : Table scan is generally a good performing option when selecting a high percentage of rows from the table. The use of an index, however, may improve the performance of the query when selecting a low percentage of rows from the table.
Technical description . . . . . . . . : If an index does not exist, consider creating one whose left-most key columns match columns in the row selection. Matching more key columns in the index with columns in the row selection will result in improved performance. To try to force the use of an existing index, specify order by columns that match the left-most key columns of that index.

Message File : QSQLMSG
Library Message File : QSYS2924


BAL Application Log Documentation   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3215 Date: 20240329 Time: 160031     sap01-206 ( 3 ms )