X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/5d160ec514af97af2f430bbe9b02360ae4f0767c..59540972b64aff5351e4fc8654d5c1100c88dfc6:/sql/indices.src.sql

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);
