cancel
Showing results for 
Search instead for 
Did you mean: 

Indexes

Aummad
Participant
0 Kudos

Hi,

As per requirement i need to update the indexes in queries, under the request it is mension as "many dimensions the indexes were degerated",

Please help me to fix that problem,

Thanks,

Accepted Solutions (0)

Answers (1)

Answers (1)

Aummad
Participant
0 Kudos

Hi.

i run the rsrv and i get the result

"ORACLE: Index /BIC/DZOMCESCV1701 has possibly degenerated"

how do i fix that,

Thanks

Former Member
0 Kudos

Press the 'Correct Error' button in RSRV after you run the test.

Do you award points for helpful answers?

Message was edited by:

Troy

Aummad
Participant
0 Kudos

Hi,

I did, but the problem still there,

I alway award points for helpful answers,

Thanks

Former Member
0 Kudos

Try going to the cube, right click, manage, performance tab, and delete the index immediately. Then click 'Repair indexes (immediately)'.