Ansicht
Dokumentation

12985 - Cost Based Optimizer for DB2/400

12985 - Cost Based Optimizer for DB2/400

RFUMSV00 - Advance Return for Tax on Sales/Purchases   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

Cost Based Optimizer for DB2/400

Hi Group,
We are on Kernel patch 1604 and at the Latest PTF level, in SM50
almost all the programs are seen as performing Sequential Reads which is
affecting performance very badly i want to know how does the Optimizer
works for DB2/400 if it also uses CBO then it should also access the Table
Access Statistics , i want to know how to check whether table access
statistics are getting generated or not is there any job scheduled to
update the statistics ..etc..


Any help on this...

Thnks nd Regds,

Sumanjit





__
IMPORTANT NOTICE:
This email may be confidential, may be legally privileged, and is for the
intended recipient only.
Unauthorised access, disclosure, copying, distribution, or reliance on any of it
by anyone else is prohibited and may be a criminal offence. 
Please delete if obtained in error and email confirmation to the sender.

Durban Tours - Südafrika Safari

General Data in Customer Master   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 1331 Date: 20240425 Time: 193008     sap01-206 ( 2 ms )