Rowset Properties

After a result is returned from a query, you can access several properties for the rowset.

In addition to the standard OLE-DB rowset properties, Windows Search SQL offers the following four custom properties. The GUID for this property set is {AA6EE6B0E828-11D0-B23E-00AA0047FC01}.

Windows Search supports the standard OLE-DB property DBPROP_COMMANDTIMEOUT of the DBPROPSET_ROWSET property set.

Property name PROPID/type Description
DONOTCOMPUTEEXPENSIVEPROPS 15/VT_BOOL Setting this to true prevents computing expensive properties like Results Found and Max Rank that require evaluating the whole query when any rowset property is accessed.
Maximum Rank (MAX_RANK) 6/VT_I4 The highest rank computed for any result.
Results Found (RESULTS_FOUND) 7/VT_I4 The total number of unique items for this query. For a SELECT query, this is the number of items in the rowset. For a GROUP ON query, this is the number of unique leaf items. This property does not identify the number of rows in the top-level rowset (the number of top-level groups).
Where ID (WHEREID) 8/VT_I4 The identifier for the restrictions used for a query. If a rowset is open when a new query is executed, the new query can reuse the restrictions from the older query, thereby taking advantage of the work already completed. For more information on reusing WHERE restrictions, refer to the ReuseWhere function.

 

Indexing Prioritization and Rowset Events in Windows 7