If for whatever reason you can't[1] use a spatial index, you can use something like geohash[2] as a generalized version of the "generated prefix columns that yo

If for whatever reason you can't[1] use a spatial index, you can use something like geohash[2] as a generalized version of the "generated prefix columns that you then use a prefix function on" concept mentioned in the article. [1] TBH the first thing to look at is whether this is a real constraint [2] https://en.wikipedia.org/wiki/Geohash https://en.wikipedia.org/wiki/Geohash