Defer Non-Indexed Trimming

[This is preliminary documentation and subject to change.]

DBPROP_DEFERNONINDEXEDTRIMMING optimizes query execution for a specific type of query.

If the value is VARIANT_TRUE, a maximum number of rows for the result is specified, and the sort order is by rank descending, then scope and security checking are deferred until either the maximum number of rows is reached or the query is completed. This may result in less than the expected number of hits to be returned for queries in which scope checks or security trimming removes results. The default is to optimize for recall; the result set trimming occurs in the course of executing the query.

This flag is best used when the query scope encompasses the entire catalog and all files in the result set have the same security Access Control Lists.

This property corresponds to the CiDeferNonIndexedTrimming variable in Index Server's IDQ files.

This property corresponds to the OptimizeFor variable in Index Server's ASP Query object.