on 05-08-2008 9:48 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.