01-16-2013 1:11 PM
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.
01-16-2013 1:31 PM
Look better at SE11 on the index...
Check Switch ISM_MEDIA_BASIS_MODIF activation status.
if switch activated
Else
Regards,
Raymond
01-16-2013 1:15 PM
Hi
If it is already there, just activate and use it.
Thanks
Reward points, if helpful.
01-16-2013 1:19 PM
Hi Ketan,
Thanks for the reply. The question is how to activate it. SE14 database utility does not activate the index.
01-16-2013 1:29 PM
Hi Ramanan,
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
01-16-2013 1:44 PM
Hi Aniket,
SE14 will show list of secondary indexes. It does not show extension index. Thanks for the reply.
01-16-2013 1:31 PM
Look better at SE11 on the index...
Check Switch ISM_MEDIA_BASIS_MODIF activation status.
if switch activated
Else
Regards,
Raymond
01-16-2013 1:42 PM
Thanks Raymond. The ISM_MEDIA_BASIS_MODIF is switched off. I will have to create my own index.
Regards,
Ramanan
01-16-2013 1:34 PM
Hi,
Tr like this
in se11 >then go to >indexes> then ur MESSAGE will be raise probably.
like this
Just save & activate.
Maximum number of secondary index is 9.
Hope it helps.
Thanks
Gourav.