X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/8b1a509442a3fa051146f82b8293126916ad8617..b7554d9ed8357b716d3cf31b532edc2f85f5829d:/lib-sql/tokenizer/legacy_tokenizer_indices.sql?ds=sidebyside diff --git a/lib-sql/tokenizer/legacy_tokenizer_indices.sql b/lib-sql/tokenizer/legacy_tokenizer_indices.sql index 44a2909c..d653a26d 100644 --- a/lib-sql/tokenizer/legacy_tokenizer_indices.sql +++ b/lib-sql/tokenizer/legacy_tokenizer_indices.sql @@ -1,2 +1,3 @@ -CREATE INDEX {{sql.if_index_not_exists}} idx_word_word_id +-- Required for details lookup. +CREATE INDEX IF NOT EXISTS idx_word_word_id ON word USING BTREE (word_id) {{db.tablespace.search_index}};