convert sqlite: add index on parent_place_id

[nominatim.git] / nominatim / tools / convert_sqlite.py

diff --git a/nominatim/tools/convert_sqlite.py b/nominatim/tools/convert_sqlite.py
index afae0d6b87e7b545c94bdbe06a9c8e895f1d1010..d766c6427c47649cfae6339b31defc22ccd9a63f 100644 (file)
--- a/nominatim/tools/convert_sqlite.py
+++ b/nominatim/tools/convert_sqlite.py
@@ -113,6 +113,7 @@ class SqliteWriter:
         await self.create_spatial_index('osmline', 'linegeo')
         await self.create_spatial_index('tiger', 'linegeo')
         await self.create_index('placex', 'place_id')
+        await self.create_index('placex', 'parent_place_id')
         await self.create_index('placex', 'rank_address')
         await self.create_index('addressline', 'place_id')