Gets or sets a value that indicates whether to use scan and filter rows or not.

Namespace: Hypertable
Assembly: ht4n (in ht4n.dll) Version: 0.9.8.11 (0.9.8.11)

Syntax

         
 C#  Visual Basic  Visual C++ 
public bool ScanAndFilter { get; set; }
Public Property ScanAndFilter As Boolean
	Get
	Set
public:
property bool ScanAndFilter {
	bool get ();
	void set (bool value);
}

Remarks

The scan and filter rows option can be used to improve query performance for queries that select a very large number of individual rows. The default algorithm for fetching a set of rows is to fetch each row individually, which involves a network roundtrip to a range server for each row. Supplying the scan and filter rows option tells the system to scan over the data and filter the requested rows at the range server, which will reduce the number of network roundtrips required when the number of rows requested is very large.

Scan and filter should be used if query more than 10% of all rows in a table.

See Also