RTREE Indexing
When running queries on a geospatial column that does WHERE checks using ST_Within, ST_Intersects, ST_Equals, and other geospatial functions, creating an index on the column can improve performance.
Example:
CREATE INDEX shape_index ON location (shape_column) WITH STRUCTURE=RTREE;
Last modified date: 08/28/2024