Kontakt

Ansicht
Dokumentation

02557 - Forcing DB2/400 to use an index ?

02557 - Forcing DB2/400 to use an index ?

TXBHW - Original Tax Base Amount in Local Currency   BAL Application Log Documentation  
This documentation is copyright by SAP AG.
SAP E-Book

Forcing DB2/400 to use an index ?

Hi Betsy,

YES!

But normally it is not necessary to delete the SQL-Packs, because at every
"full-open" the optimizer SHOULD reconsider the access-plan. This happens at
least after every SAP restart.
When this doesn't help, try to delete the SQL-packs this helps sometimes as
well, even when it shouldn't be necessary.

Regards

Volker

 Durban Tours - Südafrika Safari

ROGBILLS - Synchronize billing plans   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 771 Date: 20240602 Time: 220430     sap01-206 ( 2 ms )