Ansicht
Dokumentation

SQL4009 - Index created for table &1. ( OS/400 )

RFUMSV00 - Advance Return for Tax on Sales/Purchases   General Material Data  
This documentation is copyright by IBM.


Message : SQL4009
Index created for table &1.

Message Long Text :

Cause . . . . . : A temporary index was built to access rows from the table for one of the following reasons:
-- Perform specified ordering/grouping criteria.
-- Perform specified join criteria.
The table number refers to the relative position of this table in the query.
Recovery . . . : To improve performance, consider creating a permanent index if the query is run frequently. The query can be run in debug mode (STRDBG) to determine the specific reason the index was created and the key columns used when creating the index. NOTE: If permanent index is created, it is possible the query optimizer may still choose to create a temporary index to access the rows from the table.

Message File : QSQLMSG
Library Message File : QSYS2924


General Data in Customer Master   CPI1466 during Backup  
This documentation is copyright by IBM.

Length: 3215 Date: 20240425 Time: 162855     sap01-206 ( 2 ms )