Archived discussions are read-only. Learn more about Q&A or ask a question.

Extension Index in SAP

Hello Experts,

I have a requirement to create secondary index on VBPA for fields PARVW and KUNNR. In VBPA i could see an extension index already available. The status of the index is new and there is a warning that says Index does not exist in MSSQL. Is it possible to activate this index and will it improve the performance if activated?

Please help.

Regards,

Ramanan R.S.

Tags:
  • SAP Mentor
replied

Look better at SE11 on the index...

Check Switch ISM_MEDIA_BASIS_MODIF activation status.

if switch activated

Else

  • Transactions SE11, SE14 or DB02 wont have any effect (Read the activation log if you already tried)
  • Create you own index in your namespace (like VBPA~Z01) (but activate in production outside of peak hours)

Regards,

Raymond

0 View this answer in context