I have two tables, one with 66 thousand points and other with 5.5 thousand polygons. I'm trying to correlate which point is in which polygon and it is taking a long time. I want to know if spatial indexing should improve the query speed.
The polygon layer is already simplified and I've already created the spatial index for both the coordinates layer and the polygons layer.
I've tried this on PostGIS with SQL queries and in QGIS with it's Point in Polygon algorithm. Both of them take several minutes to process.
Does spatial indexing really help with this kind of problem, or just the nearest neighbors or intersections kinds of problems?