Create spatial indexes for OSMM ITN

CREATE INDEX ferrylink_geom_idx ON itn.ferrylink USING GIST (wkb_geometry); COMMIT; CREATE INDEX ferrynode_geom_idx ON itn.ferrynode USING GIST (wkb_geometry); COMMIT; CREATE INDEX infopoint_geom_idx ON itn.informationpoint USING GIST (wkb_geometry); COMMIT; CREATE INDEX roadlink_geom_idx ON itn.roadlink USING GIST (wkb_geometry); COMMIT; CREATE INDEX roadlinkinfo_geom_idx ON itn.roadlinkinformation USING GIST (wkb_geometry); COMMIT; INDEX roadnode_geom_idx ON itn.roadnode USING GIST (wkb_geometry); COMMIT;

Did this page help you?