|Delegation Rules: WHERE Clause / WHERE Clause Examples for Delegation|
EnvelopesIntersect is a boolean spatial operator that evaluates whether the envelopes for both objects intersects. The envelope is also referred to as the MBR (minimum bounding rectangle).
SELECT city FROM table WHERE obj EnvelopesIntersect <geometry>
If the data source provider supports EnvelopesIntersect, the entire query is delegated to the data provider.
If the data source provider does not support EnvelopesIntersect, part of the query is delegated, as follows:
SELECT city, obj FROM table
Spectrum Spatial executes the entire query, using the results from the data source provider:
SELECT city FROM <results from the delegation> WHERE obj EnvelopesIntersect <geometry>