Filter Method

SqlGeometry.Filter Method

Offers a fast, index-only intersection method to determine if a SqlGeometry instance intersects another SqlGeometry instance, assuming an index is available.

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public SqlBoolean Filter(
	SqlGeometry other


Type: Microsoft.SqlServer.Types.SqlGeometry
Specifies the SqlGeometry instance to compare to the current SqlGeometry.

Return Value

Type: System.Data.SqlTypes.SqlBoolean
A SqlBoolean that specifies whether the specified SqlGeometry intersects the calling SqlGeometry. If the instances do intersect, this method returns true. Otherwise, it returns false.

This method returns true if a SqlGeometry instance potentially intersects another SqlGeometry instance. This method may produce a false positive return, and the exact result may be plan-dependent. Returns an accurate false value (true negative return) if there is no intersection of SqlGeometry instances found.

In cases where an index is not available, or is not used, the method will return the same values as STIntersects when called with the same parameters.

Community Additions

© 2016 Microsoft