SQLServer STContains() performance
Dennis GuseFor some reason SQLServer 2017 is picky with regard to performance for geography comparisons.
The first statement seems is rather slow (seems to ignore spatial indeces) while the second one works impressively fast on my data.
NOTE: I would prefer the first variant as technically NOT(False) is TRUE and TRUE is everything except 0.