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?
SE14 activates the indexes.
Go to SE14 and click on Indexes button on the application toolbar of the screen.
A Pop-Up will appear showing the indexes of the table.
Double click on the one you want to activate.
The click Activate and Adjust Database button.
Hope this helps
Look better at SE11 on the index...
Check Switch ISM_MEDIA_BASIS_MODIF activation status.
if switch activated