Ansicht
Dokumentation
SQL4010 - Table scan access for table &1. ( OS/400 )
TXBHW - Original Tax Base Amount in Local Currency General Data in Customer MasterThis documentation is copyright by IBM.
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 )