cancel
Showing results for 
Search instead for 
Did you mean: 

In - DB13 - warnings for missing indexes

Former Member
0 Kudos

Hi

I've noticed in the results of the DBCHECK job in DB13 that we have a number of warnings for missing indexes.

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPR3./BI0/PCOSTELMNT

The strange thing is that no missing indexes are picked up be DB02. In SE11 these tables cannot be found. Checked at Oracle level and the tables exist but the indexes do not.

Does anyone know if these tables should have indexes?

If so what would be the best way to create these?

Thanks & Regards

Shishir

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks

Former Member
0 Kudos

In DB02 they are probably showing under 'Optional Indexes' under 'not created'