Register Login

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.

×