Ansicht
Dokumentation

SQL4011 - Index scan-key row positioning used on table &1. ( OS/400 )

TXBHW - Original Tax Base Amount in Local Currency   BAL Application Log Documentation  
This documentation is copyright by IBM.


Message : SQL4011
Index scan-key row positioning used on table &1.

Message Long Text :

Cause . . . . . : Index scan-key row positioning is defined as applying selection against the index to position directly to ranges of keys that match some or all of the selection criteria. Index scan-key row positioning only processes a subset of the keys in the index and is a good performing option when selecting a small percentage of rows from the table.
The table number refers to the relative position of this table in the query.
Recovery . . . : Refer to the DB2 for i - Database Performance and Query Optimization topic collection in the Database category in the IBM i Information Center, http://www.ibm.com/systems/i/infocenter/, for more information on index scan-key row positioning.

Message File : QSQLMSG
Library Message File : QSYS2924


CPI1466 during Backup   General Material Data  
This documentation is copyright by IBM.

Length: 3232 Date: 20240425 Time: 085414     sap01-206 ( 2 ms )