on 03-27-2012 10:18 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.