X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/8f3845660f18bdbf2dd42dd2c6db6c7fa5160f3e..28101967ef5b89b85f492304b1002b8a85e6fe21:/nominatim/tokenizer/icu_tokenizer.py

diff --git a/nominatim/tokenizer/icu_tokenizer.py b/nominatim/tokenizer/icu_tokenizer.py
index 4b9dac69..70273b90 100644
--- a/nominatim/tokenizer/icu_tokenizer.py
+++ b/nominatim/tokenizer/icu_tokenizer.py
@@ -163,6 +163,8 @@ class ICUTokenizer(AbstractTokenizer):
                 else:
                     LOG.info('Computing word frequencies')
                     cur.drop_table('word_frequencies')
+                    cur.execute('ANALYSE search_name')
+                    cur.execute('ANALYSE word')
                     cur.execute("""
                       CREATE TEMP TABLE word_frequencies AS
                       WITH word_freq AS MATERIALIZED (
@@ -190,6 +192,7 @@ class ICUTokenizer(AbstractTokenizer):
                                             END) as info
                                     FROM word LEFT JOIN word_frequencies wf
                                          ON word.word_id = wf.id
+                                    ORDER BY word_id
                                 """)
                     cur.drop_table('word_frequencies')