cancel
Showing results for 
Search instead for 
Did you mean: 

MISSING_INDEX

Former Member
0 Kudos

Dear All,

How I rectify this warning:

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3./BIC/0CTR000016

Thanks

MS

Accepted Solutions (1)

Accepted Solutions (1)

paul_power
Active Contributor
0 Kudos

Dear MS,

It is common to have unusuable indexes in BW as indexes are dropped and

recreated during the loading processes, if indexes are not created

locally afterwards they can become unusable.  The warnings from the

checkdb show that the above indexes are missing.  Please check in

DB02 if the indexes exist.  Indexes for BW should never be created via

SE14 or DB02.  Please refer to oss notes #1455000 and #515711 for

solution steps.

regards,

Paul

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

im not sure you should correct all warning you find but a new index will not harm your system

Go to se14, specify the table then at the following screen click index and create a Z01 for example

Let me know if you need further details

a