X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/388ebcbae2b895279727edafebfb8ed794f0c4cc..5c778c6d322b65337bc1a1a54cbc1201f4e6656e:/lib-sql/tokenizer/legacy_tokenizer_indices.sql 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}};