Index is possibly denegerated

[Former Member]

When I was running T-Code RSRV to test the index for a cube, there was a warning saying that one InfoObject index is possibly degenerated.

I try to use correct errors function in the toolbar. But it didn't work.

Does anyone have any clue on this?

Thanks,

Glen

[Former Member]

Hi,

The problems occur under at least one of the following conditions:

(1) The queries or aggregates use hierarchies which are reloaded regularly.

(2) Requests have been deleted from the InfoCube and new data has been loaded afterwards.

(3) You carry out regular rollups without newly setting up the aggregate indexes in between

Solution:

(a) DROP INDEX ..., and CREATE INDEX ... afterwards

b) ALTER INDEX <index name> REBUILD

Check the OSS Note 323090

-Vikram

[Former Member]

Hi

Go through forum

santosh

[former_member184494]

One way to do this is to check the inde size in DB02 - and then rebuild the same in DB02 using the DB rebuild index option from the menu....