This topic provides the detailed information on where defining LOV is mandatory for handling the high volume data.

This parameter should be specified during the definition of LOV in Open Development Tool. If this parameter is selected, then total wild card search (by providing blank or % in reduction fields) won’t be allowed on fields where the particular LOV is attached.

In the LOV definition screen, Is Mandatory option would be enabled for all Reduction Fields. This feature is not available for Global LOVs.