Create spatial index for OSMM Sites Layer

MySQL

CREATE INDEX accesspoint_geom_idx ON sites.accesspoint USING gist (wkb_geometry);
COMMIT;
 
CREATE INDEX functionalsite__geom_idx ON sites.functionalsite USING gist (wkb_geometry);
COMMIT;
 
CREATE INDEX routingpoint__geom_idx ON sites.routingpoint USING gist (wkb_geometry);
COMMIT;