X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/9086a794a1ca9ed08d66c9aca5cea25d1f6006bf..1b1ed820c3af58de7281607a8b82f6a5dfe37319:/lib-sql/tiger_import_finish.sql diff --git a/lib-sql/tiger_import_finish.sql b/lib-sql/tiger_import_finish.sql index 39ab1ae3..85bb5e3e 100644 --- a/lib-sql/tiger_import_finish.sql +++ b/lib-sql/tiger_import_finish.sql @@ -1,5 +1,5 @@ --index only on parent_place_id -CREATE INDEX {{sql.if_index_not_exists}} idx_location_property_tiger_place_id_imp +CREATE INDEX {{sql.if_index_not_exists}} idx_location_property_tiger_parent_place_id_imp ON location_property_tiger_import (parent_place_id) {{db.tablespace.aux_index}}; CREATE UNIQUE INDEX {{sql.if_index_not_exists}} idx_location_property_tiger_place_id_imp ON location_property_tiger_import (place_id) {{db.tablespace.aux_index}};