DBPROP_DEFERNONINDEXEDTRIMMING

Note

Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.

 

The DBPROP_DEFERNONINDEXEDTRIMMING property optimizes query execution for a specific type of query.

Summary

Property Set DBPROPSET_QUERYEXT
Property ID DBPROP_DEFERNONINDEXEDTRIMMING
Value Type DBTYPE_BOOL
Default VARIANT_FALSE

 

Remarks

If the value is VARIANT_TRUE, a maximum number of rows for the result is specified, and the sort order is by rank descending. Scope and security checking are deferred until the maximum number of rows is reached or the query is completed. This may result in less than the expected number of hits for queries in which scope checks or security trimming remove some 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 the Internet Data Query Files of Indexing Service.

This property corresponds to the OptimizeFor variable in Indexing Service's Query object.