cancel
Showing results for 
Search instead for 
Did you mean: 

db6 - clusterratio under 80 percent

andreas_busch
Explorer
0 Kudos

dear experts,

an index has a clusterration of under 80% - is it possible that this one will not be used for the optimizer?

... so the optimizer decided to use another one which got a better clusterratio?

thanks in advance.

best regards

Accepted Solutions (1)

Accepted Solutions (1)

former_member197561
Active Participant
0 Kudos

Dear Andreas,

For some databases, there is index usage statistics:

http://help.sap.com/saphelp_bpc70sp02/helpdata/en/a4/f190e1bd90476fa4ac25b895866f8f/frameset.htm

In transaction \nST05, if you record your sql exectution, you can check with "Explain" the execution of the sql statement and see if indexes are used.

Best Regards,

Sylvia

Answers (0)