Missing index in DBcheck and DBACockpit

[Former Member]

hi gurus,

In DB check i'm getting following warning:

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.ZBIMIS

Also when i go and check in DBACOCKPIT and check for Missing tables and indices

i find ZBIMIS -0 in objects missing Primary Indexes.

how do i create indexes for this.

Also in optional indexes, i have 353 indexes not created. What should be done to this.

Kindly help.

Thanks & Regards,

Priya

[former_member204746 · Accepted solution]

hi,

ZBIMIS -0

simply go into Se14 and create the index.

or better yet, find who created that object and ask him to create the index himself with ABAP tools.

[Former Member · Accepted solution]

hi,

I have already created primary index for ZBIMIS using SE14.

But what about the optional Indexes. There are 353 of them at present.

I can not e indexes for each of them individually. Its quite cumbersome.

Also i was trying for few of them. but for whatever the indexes were missing, whenever i was trying to create using SE14: it gave warning as "Does not exist in database" & Not defined as DB Index in the ABAP Dictionary". also the Activate and Adjust Database tab is disabled. How to go about it

Regards,

Priya

[Former Member · Accepted solution]

Hello Priya,

simply ignore all these "additional" or "optional" indexes. They might be helpful

for some specific performance problem. In general you won't need them

and they would be bad for the update performance if you enable them

without a real need.

I always ignored them and never needed one of them to be created.

Regards,

Mark

[former_member204746 · Accepted solution]

I'm with Mark, i usually ignore those optional indexes. I once decided to create them and this created issues during an upgrade... I had to delete them...

[Former Member]

Hi Priya,

Looks like someone created a Z table without an index.. In case you don't have heavy sql statements on this table, you can leave it as is..

The optional indexes are predefined indexes that are delivered with SAP. In some circumstances you could create one of these indexes. If there is no need for it, just leave them, since they only occupy additional space.

Kind regards,

Mark