Skip to Content
0
Former Member
Nov 12, 2012 at 10:18 PM

MISSING_INDEX: Table: SAPSR3.TLOCKP_TMP # Table has no index

515 Views

Hi Gurus,

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

SAPSR3.TLOCKP_TMP

SAPSR3.ZTLOCKP

SAPSR3.ZTLOCKPC

In SE11 these tables cannot be found. I dont know how to check the tables at oracle level, can anybody tell me how to check at oracle level?

Does anyone know if these tables should have indexes?

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

Regards,

Raj