use address counts for improving index lookup

[nominatim.git] / 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 44a2909c108a76d321a47bbc9e46626f1a5b657e..016c518a65b2de9c1c9d409c7d983ee3d3a641de 100644 (file)
--- a/lib-sql/tokenizer/legacy_tokenizer_indices.sql
+++ b/lib-sql/tokenizer/legacy_tokenizer_indices.sql
@@ -1,2 +1,10 @@
-CREATE INDEX {{sql.if_index_not_exists}} idx_word_word_id
+-- 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.
+
+-- Required for details lookup.
+CREATE INDEX IF NOT EXISTS idx_word_word_id
   ON word USING BTREE (word_id) {{db.tablespace.search_index}};