Ansicht
Dokumentation

SQL4023 - Parallel table prefetch used. ( OS/400 )

SQL4023 - Parallel table prefetch used. ( OS/400 )

General Data in Customer Master   ABAP Short Reference  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL4023
Parallel table prefetch used.

Message Long Text :

Cause . . . . . : The query optimizer chose to use a parallel prefetch access method to reduce the processing time required for the table scan.
Recovery . . . : Parallel prefetch can improve the performance of queries. Even though the access plan was created to use parallel prefetch, the system will actually run the query only if the following are true:
-- The query attribute degree was specified with an option of *IO or *ANY for the application process.
-- There is enough main storage available to cache the data being retrieved by multiple I/O streams. Normally, 5 megabytes would be a minimum. Increasing the size of the shared pool may improve performance.
For more information on parallel table prefetch, 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/.

Message File : QSQLMSG
Library Message File : QSYS2924


Fill RESBD Structure from EBP Component Structure   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3217 Date: 20240329 Time: 100503     sap01-206 ( 3 ms )