Create attribute indexes for OSMM ITN
CREATE INDEX idx_ferrylink_fid ON itn.ferrylink(fid);
COMMIT;
CREATE INDEX idx_ferrynode_fid ON itn.ferrynode(fid);
COMMIT;
CREATE INDEX idx_infopoint_fid ON itn.informationpoint(fid);
COMMIT;
CREATE INDEX idx_road_fid ON itn.road(fid);
COMMIT;
CREATE INDEX idx_road_descgroup ON itn.road(descriptivegroup);
COMMIT;
CREATE INDEX idx_roadlink_fid ON itn.roadlink(fid);
COMMIT;
CREATE INDEX idx_roadlink_descgroup ON itn.roadlink(descriptivegroup);
COMMIT;
CREATE INDEX idx_roadlink_descterm ON itn.roadlink(descriptiveterm);
COMMIT;
CREATE INDEX idx_roadlinkinfo_fid ON itn.roadlinkinformation(fid);
COMMIT;
CREATE INDEX idx_roadlinkinfo_class ON itn.roadlinkinformation(classification);
COMMIT;
CREATE INDEX idx_roadnode_fid ON itn.roadnode(fid);
COMMIT;
CREATE INDEX idx_roadnodeinfo_fid ON itn.roadnodeinformation(fid);
COMMIT;
CREATE INDEX idx_roadnodeinfo_geom ON itn.roadnodeinformation(classification);
COMMIT;
CREATE INDEX idx_roadrouteinfo_fid ON itn.roadrouteinformation(fid);
COMMIT;
CREATE INDEX idx_roadrouteinfo_instr ON itn.roadrouteinformation(instruction);
COMMIT;
Updated less than a minute ago