Thanks, I will ad STIntersects to my list of things to test out. And yeah, BETWEEN on integer comparison absolutely kills performance, it was the reason I started doing this experimental stuff with spatial data in the first place. I'm not sure, but I am pretty sure that I set the miny and maxy bounding box to -1 and 1 respectively.