Rowset Properties

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 namePROPID/typeDescription
DONOTCOMPUTEEXPENSIVEPROPS15/VT_BOOLSetting 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_I4The highest rank computed for any result.
Results Found (RESULTS_FOUND)7/VT_I4The 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_I4The 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.


Related topics

Indexing Prioritization and Rowset Events in Windows 7



Community Additions

© 2015 Microsoft