Create attribute indexes for BoundaryLine
CREATE INDEX countyelectoral_name_idx ON boundaryline.county_electoral_division_region(name);
COMMIT;
CREATE INDEX countyregion_name_idx ON boundaryline.county_region(name);
COMMIT;
CREATE INDEX districtboroughregion_name_idx ON boundaryline.district_borough_unitary_region(name);
COMMIT;
CREATE INDEX districtboroughward_name_idx ON boundaryline.district_borough_unitary_ward_region(name);
COMMIT;
CREATE INDEX europeanregion_name_idx ON boundaryline.european_region_region(name);
COMMIT;
CREATE INDEX greaterlondon_name_idx ON boundaryline.greater_london_const_region(name);
COMMIT;
CREATE INDEX parishregion_name_idx ON boundaryline.parish_region(name);
COMMIT;
CREATE INDEX scotwalesconstregion_name_idx ON boundaryline.scotland_and_wales_const_region(name);
COMMIT;
CREATE INDEX scotwalesregion_name_idx ON boundaryline.scotland_and_wales_region_region(name);
COMMIT;
CREATE INDEX unielecdiv_name_idx ON boundaryline.unitary_electoral_division_region(name);
COMMIT;
CREATE INDEX westminster_name_idx ON boundaryline.westminster_const_region(name);
COMMIT;
Updated less than a minute ago