mnc_full_index_filter prevents SAP ASE from considering noncovered indexes that do not have a limiting search argument at the server level, if there is a column in the index or a predicate that does not have a histogram.
|
Summary Information |
|
|---|---|
|
Default value |
2 |
|
Range of values |
0 – 2
|
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Query Tuning |
You can use mnc_full_index_filter on data-only-locked (DOL) tables in which you have the intelligent index scan, even though the intelligent index scan manufactures search arguments.
Changing the value of mnc_full_index_filter does not increase the amount of memory SAP ASE uses.
mnc_full_index_filter is not enabled for any specific optional goal; the only way to obtain the behavior is to explicitly enable it.