cancel
Showing results for 
Search instead for 
Did you mean: 

OPTIMIZE_QUAL_ON_INDEX MaxDB support parameter

Adrie
Explorer
0 Kudos

Hello,

On our SAP BW systems we see that the default value of the MaxDB support parameter OPTIMIZE_QUAL_ON_INDEX has changed from NO to YES by SAP.

I can not find any documentation on this parameter. Can anybody tell me what this parameters does on accessing tables and when this is used?

Kind regards,

Adrie Verdoes

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

Hi Adrie,

this parameter switches on/off the considerations of additional qulifications on an index by the optimizer.

There are some bug in older versions of MaxDB that made it necessary to turn this off (e.g.PTS 1149671)

Which version of MaxDB do you use?

Anyhow: in general this parameter should be set to YES.

KR Lars

Adrie
Explorer
0 Kudos

Hi Lars,

Thanks for your answer. I needed to know more of this parameter because is giving problems on MaxDB 7.6.04.11. I will send you the number of the SAP OOS call seperaly by mail.

Thanks,

Adrie

lbreddemann
Active Contributor
0 Kudos

Hi Adrie,

Concerning the parameter:

There is not really more to know about this parameter.

The problem you face (the issue you described in your support message) is not how it should be - it looks like a bug.

Best regards,

Lars

Answers (0)