mnc_full_index_filter

Prevents Adaptive Server from considering noncovered indexes that do not have a limiting search argument at the server level if there is:

A column in the index
A predicate that does not have a histogram

Summary information
Default value	2
Range of values	0 – 2 0 – disable 1 – enable 2 – set according to the optimization goal setting
Status	Dynamic
Display level	Comprehensive
Required roles	system administrator
Configuration group	Query tuning

Prevents Adaptive Server from considering noncovered indexes that do not have a limiting search argument at the server level if there is:

A column in the index
A predicate that does not have a histogram

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 Adaptive Server uses.

mnc_full_index_filter is not enabled for any specific optional goal; the only way to obtain the behaviour is to explicitly enable it.