From 12bfcce50b2f9ab4564f8aeed3ec636e657fe17f Mon Sep 17 00:00:00 2001 From: Kaj-Michael Lang Date: Tue, 30 Oct 2007 21:00:07 +0200 Subject: [PATCH] Add indexes for nls names --- docs/osm-indexes.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/docs/osm-indexes.sql b/docs/osm-indexes.sql index 0789aeb..59ddfaa 100644 --- a/docs/osm-indexes.sql +++ b/docs/osm-indexes.sql @@ -5,6 +5,9 @@ CREATE INDEX node_lat_idx on nodes (lat); CREATE INDEX node_lon_idx on nodes (lon); CREATE INDEX way_name_idx on way_names (name); +CREATE INDEX way_name_nls_id_idx on way_names_nls (wid); +CREATE INDEX way_name_nls_name_idx on way_names_nls (name); + CREATE INDEX way_ref_idx on way_ref (ref); CREATE INDEX way_n2n_wsid_idx on way_n2n (wsid); -- 2.39.5