X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/65aba66c99903322bc56c7ca99ac29446dd94d09..624df40f43cc4131b823fbef218fd0c08d6400b2:/sql/indices.src.sql?ds=sidebyside

diff --git a/sql/indices.src.sql b/sql/indices.src.sql
index 37d53a05..4685ae2f 100644
--- a/sql/indices.src.sql
+++ b/sql/indices.src.sql
@@ -28,3 +28,6 @@ CREATE INDEX idx_location_property_-partition-_centroid ON location_property_-pa
 -- end
 
 CREATE UNIQUE INDEX idx_place_osm_unique on place using btree(osm_id,osm_type,class,type);
+
+
+CREATE INDEX idx_gb_postcode_postcode ON gb_postcode USING BTREE (postcode);
