Important is that 1 value need to be on the right side of the equation. Otherwise spatial index is not used. https://learn.microsoft.com/en-us/sql/relational-databases/spatial/spatial-indexes-overview?view=sql-server-ver16#queries-that-use-spatial-indexes