Skip to Content
0
Former Member
Jul 25, 2016 at 05:13 AM

Index Issue in CUBE

36 Views

Hi Experts,

I have performance issues with the one of the BW Inventory related cube. Which contains around 10 milion records.

When I checked the indexes, it is in red status. So I checked the problem in RSRV and found below issues.

Kindly suggest how to rectify the below issues.

Index /BIC/EZIC_C03 100 does not exist in the database

Index /BIC/EZIC_C03 110 does not exist in the database

Index /BIC/EZIC_C03 120 does not exist in the database

Index /BIC/EZIC_C03 100 does not exist in the database

Index /BIC/EZIC_C03 110 does not exist in the database

Index /BIC/EZIC_C03 120 does not exist in the database

Index /BIC/EZIC_C03 P is LOCAL. GLOBAL was expected 1

FYI., CUBE data is compressed and we have 0 records in F Table. And we have recently partitioned the table.

Best Regards,

Krishna