MISSING_INDEX, object: (table)

[Former Member]

Hello All,

I am getting missing index warning in dbcheck.

When I checked on SAP both table and index is active.

But index is unusable on db level.

But also I cannot find the entry for the same in db02, missing index.

Please advise.

Thanks,

Anu

[stefan_koehler]

Hello Anu,

> But index is unusable on db level.

Have you checked this with the following sql statement:

SQL> SELECT STATUS FROM ALL_INDEXES WHERE INDEX_NAME = '<INDEX_NAME>';

If the status is UNUSABLE just rebuild the index.

Regards

Stefan

[Former Member]

Thanks but please note that I am not getting error for missing_statistics but for missing_index.

Thanks

Anu.

[Former Member]

Please post your dbcheck logu2026u2026

[former_member204746]

missing index? If this is not a BW system, go into SE14 and create the missing index.

[Former Member]

If You 're getting following error Error in db13 while executing "CHECKDB" Action, then perform the following:

Error :

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPsid.table~index

Solution:

Login to OS by using SIDadm user.

enter the command brconnect -c -u / -f stats -t tablename

run check db to see the error is resolved.

Also always schedule the "UPDATSTAT" 1st then "CHECKDB" in db13.