Missing Indexes

[Former Member]

Hi I found some missing indexes..and i repaired the missing indexes. after one week i again missing indexes on another table. anybody can explain me why indexes are deleted frequently. please explain me the reason.

Thanks

[former_member228339]

Hi..

SAP_INFOCUBE_INDEXES_REPAIR – This program checks that all the indexes for all the cubes exist as they should. If they don’t, it will repair/rebuild them. Alternatively you can use RSRV to check the status of a cube’s indexes. If you see many missing indexes in DB02 (..> Missing indexes) you should run this.

Database Data Dictionary for consistency Ensure DB Statistics are up to date prior to the upgrade

[Former Member]

My Question is why indexes miss frequently. what is the reason???