Skip to Content
0
Former Member
Nov 06, 2012 at 10:08 AM

Increase the number of distinct values for the field PROCESS in the index BDCP2~001 from 2 to 100

59 Views

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