Register Login
Python Photoshop SAP Java PHP Android C++ Hadoop Oracle Interview Questions Articles Other

Missing index in SAP

Updated May 18, 2018

Hello All,
 
 
Table and index both are active in SAP but index is unusable at db level.
 
Please advise.
 
Thanks & Regards,

 

Comments

  • 04 Jul 2010 8:43 am rekha
    Hi,

    Have you tried SE14 ? if not, go to SE14. enter table name. Then select the index. then craete in database. or click on activate & adjust.
    Hope your problem will be resolved.
  • 04 Jul 2010 8:44 am rekha
    Thanks,

    But should i create the index from SE14 or from db level with the command

    alter index "SAPSID"."/BIC/FABCk001~040" rebuild online;
    alter index "SAPSID"."/BIC/FABCk001~040" rebuild partition "/BIC/FABCK0010000000288" online;
    System is netweaver 2004s.

    Please suggest.
  • 23 Sep 2010 7:15 am rekha
    Hi,

    It will be easy to create from SE14. Also direct from db level should not be suggested by me as there is already a another option exist.
Recommended Posts:
×