I am trying to figure out points reside inside an rectangular area (envelope). I am having a little bit difficulty understanding performance implications of using
&& operator compared to
However I think I explained my own question while trying to formulate my question. I submit it anyway in case it would be useful to somebody.
The manual for && says (ironically the page name is geometry_overlaps.html):
&& — Returns TRUE if A's 2D bounding box intersects B's 2D boundingbox.`
The manual for ST_Intersects says:
Returns TRUE if the Geometries/Geography "spatially intersect in 2D" - (share any portion of space) and FALSE if they don't (they are Disjoint). For geography -- tolerance is 0.00001 meters (so any points that close are considered to intersect)
ST_Intersects will return true in such cases. For my objective
&& operator does almost same thing since I am using a rectangular bounding box in either case. I am wondering if
&& is the fastest operator for my purpose? It feels like
&& has to do less checks so it must be much more efficient.
Here is an example which is direct copy from
SELECT t1.id AS t1, t2.id AS t2, t1.ln && t2.ln AS "&&", ST_Intersects(t1.ln,t2.ln) FROM ( VALUES (1, 'LINESTRING(0 0, 3 3)'::geometry), (2, 'LINESTRING(0 1, 0 5)'::geometry) ) AS t1(id,ln) CROSS JOIN (VALUES (3, 'LINESTRING(1 2, 4 6)'::geometry) ) AS t2(id,ln); t1 | t2 | && | st_intersects ----+----+----+--------------- 1 | 3 | t | f 2 | 3 | f | f (2 rows)
Below is a simple graph of how these lines should look like. I just added plotted this to see how bounding box works exactly for lines. For my purposes, the points are always inside the box (while this line example does not really reflect what I am trying to do but good for illustration)
Question 1 is if
&& is significantly faster than
ST_Intersects when using with
ST_MakeEnvelope (a rectangular boundary), when finding points inside a rectangular bounding box.
Question 2 is Also am I understanding correctly that when checking points inside a rectangular boundary
&& does exactly same thing as