Missing Secondary Indexes on BI System

[Former Member]

Hi experts

I have a sap bi system with 67 missing secondary indexes.

Can you please tell me what is best practice with secondary Indexes, should I create them by default or not ?

[former_member188883]

Hi Vioar,

In BI process chains there is always a step to drop and recreate secondary indexes.

So in DB02 of BI system you will always find some list of secondary indexes which are missing.

You may need to discuss this with BI Functional consultant before you re-create these indexes.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Tx .

[Sriram2009]

Hi

Check this SAP note

  1094305 - BW indexes with incorrect names

BR

SS

[Former Member]

Hello,

Yes you need create this indexes.

You can learn more about indexes in URL:

https://help.sap.com/saphelp_nw70/helpdata/en/cf/21eb20446011d189700000e8322d00/content.htm

Best regards

Joao Vagarinho