Hi,
SAP has just concluded Go-Live Checks service on our ECC system. They found out that there was an access on BDCP2 causing high database load:
SQL Statement
SELECT
"MANDT", "MESTYPE", "CPIDENT", "PROCESS", "TABNAME", "TABKEY", "FLDNAME", "CRETIME", "ACTTIME", "USRNAME", "CDOBJCL", "CDOBJID", "CDCHGNO", "CDCHGID"
FROM
"BDCP2"
WHERE
"MANDT"=:A0 AND "MESTYPE"=:A1 AND "PROCESS"=:A2
ORDER BY
"MANDT", "CPIDENT"
For this, their Recommendation: Increase the number of distinct values for the field PROCESS in the index BDCP2~001 from 2 to 100. Please test this recommendation and review performance.
How to implement their recommendations (i.e., increase the number of distinct values for the field PROCESS) ?
Any clues would be helpful.
Thanks,
Abdul