DB13 Warning MISSING_INDEX

[Former Member]

I am receiving a warning in my DB!3 Check DB that states the following tables are MISSING_INDEX: SAPR3.DICTOOLS_FREE_SPACE, SAPR3.LORENZFIDEPRDCTRL, and SAPR3.LORENZFITRPRDEPR. Does anyone know what these tables are and if they should have an index or if I can ignore the warning?

Thanks,

Jackie

[Former Member]

Hi,

BRTOOLS can be used to rebuild index.

BRTOOLS->SEGMENT MGT->REBUILD INDEX.

A personal opnion: I always try to rectify all the warnings.

Hope this helps.

Pl dont forget to award a point

Regards

[former_member204746]

DICTOOLS_FREE_SPACE comes from an internet-supplied script: http://www.lazydba.com/oracle/0__10429.html

LORENZ* tables are probably customer tables that do not start with Z.

you can probably ignore them. DICTOOLS_FREE_SPACE is in schema SYSTEM for me...

[Former Member]

I am also seeing it in BW with the following tables: SAPBIW./BIC/FZPM_C01 and SAPBIW./BIC/FZPM_C99.