X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/b1d490ea53c2fddb3fe2c5466267e898e87e743e..ecf4693a799055b3795ca691337941f931cf0a59:/lib-sql/tiger_import_finish.sql?ds=sidebyside diff --git a/lib-sql/tiger_import_finish.sql b/lib-sql/tiger_import_finish.sql index fb76477c..c02ce2a3 100644 --- a/lib-sql/tiger_import_finish.sql +++ b/lib-sql/tiger_import_finish.sql @@ -1,8 +1,15 @@ +-- SPDX-License-Identifier: GPL-2.0-only +-- +-- This file is part of Nominatim. (https://nominatim.org) +-- +-- Copyright (C) 2022 by the Nominatim developer community. +-- For a full list of authors see the git log. + --index only on parent_place_id CREATE INDEX IF NOT EXISTS idx_location_property_tiger_parent_place_id_imp ON location_property_tiger_import (parent_place_id) {% if postgres.has_index_non_key_column %} - INCLUDE (startnumber, endnumber) + INCLUDE (startnumber, endnumber, step) {% endif %} {{db.tablespace.aux_index}}; CREATE UNIQUE INDEX IF NOT EXISTS idx_location_property_tiger_place_id_imp