Create Meridian2 Attribute Indexes

PL/pgSQL

CREATE INDEX meridian2_aroad_number ON meridian2.a_road_polyline (number);
COMMIT;
CREATE INDEX meridian2_aroad_name ON meridian2.a_road_polyline (road_name);
COMMIT;
CREATE INDEX meridian2_broad_number ON meridian2.b_road_polyline (number);
COMMIT;
CREATE INDEX meridian2_broad_name ON meridian2.b_road_polyline (road_name);
COMMIT;
CREATE INDEX meridian2_county_name ON meridian2.county_region (name);
COMMIT;
CREATE INDEX meridian2_district_name ON meridian2.district_region (name);
COMMIT;
CREATE INDEX meridian2_dlua_name ON meridian2.dlua_region (name);
COMMIT;
CREATE INDEX meridian2_junction_name ON meridian2.junction_font_point (name);
COMMIT;
CREATE INDEX meridian2_lake_name ON meridian2.lake_region (name);
COMMIT;
CREATE INDEX meridian2_minor_number ON meridian2.minor_rd_polyline (number);
COMMIT;
CREATE INDEX meridian2_minor_name ON meridian2.minor_rd_polyline (road_name);
COMMIT;
CREATE INDEX meridian2_motorway_number ON meridian2.motorway_polyline (number);
COMMIT;
CREATE INDEX meridian2_motorway_name ON meridian2.motorway_polyline (road_name);
COMMIT;
CREATE INDEX meridian2_river_name ON meridian2.river_polyline (name);
COMMIT;
CREATE INDEX meridian2_roadnode_name ON meridian2.roadnode_point (name);
COMMIT;
CREATE INDEX meridian2_settlemt_name ON meridian2.settlemt_point (name0);
COMMIT;
CREATE INDEX meridian2_station_name ON meridian2.station_point (name);
COMMIT;
CREATE INDEX meridian2_text_name ON meridian2.text (textstring);
COMMIT;