Are GIST Index point geometry useful to speed up spatial query? I know the question is a bit generic.
I have multiple tables with point geometries and a GIST Index eating many gigabits of space.
From what I understrand about Gist Index on polygons or polylines, it will store the bounding box and computes a first calculation on the bounding box instead of the full geometry resulting in faster processing.
But what about point geometry?
Will it to anything more that ordering the points spatially?
Thanks
A GiST index on points can be very useful. It will speed up queries with st_contains, st_overlaps and similar functions in the WHERE condition, where one of the arguments is the indexed column.