X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/e7266b52ae4b9e543513df95ad853ba30a7aefb3..8b1a509442a3fa051146f82b8293126916ad8617:/lib-sql/indices.sql?ds=sidebyside diff --git a/lib-sql/indices.sql b/lib-sql/indices.sql index a6f7cf95..81299544 100644 --- a/lib-sql/indices.sql +++ b/lib-sql/indices.sql @@ -1,9 +1,6 @@ -- Indices used only during search and update. -- These indices are created only after the indexing process is done. -CREATE INDEX {{sql.if_index_not_exists}} idx_word_word_id - ON word USING BTREE (word_id) {{db.tablespace.search_index}}; - CREATE INDEX {{sql.if_index_not_exists}} idx_place_addressline_address_place_id ON place_addressline USING BTREE (address_place_id) {{db.tablespace.search_index}};