From 5ad16458b3221e662228f3fa816d875e9128515e Mon Sep 17 00:00:00 2001 From: Kaj-Michael Lang Date: Wed, 18 Jul 2007 13:36:54 +0300 Subject: [PATCH] Add index on way_seg wsid --- docs/osm-indexes.sql | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/docs/osm-indexes.sql b/docs/osm-indexes.sql index 7bbe9ab..c38c776 100644 --- a/docs/osm-indexes.sql +++ b/docs/osm-indexes.sql @@ -1,5 +1,9 @@ -CREATE INDEX node_ll_idx on nodes (lat,lon); -CREATE INDEX way_seg_node_idx on way_seg (node); CREATE UNIQUE INDEX poi_lat_lon_idx on poi (lat, lon, cat_id); CREATE INDEX poi_priority on poi (priority); + +CREATE INDEX node_ll_idx on nodes (lat,lon); + CREATE INDEX name_idx on way_names (name); + +CREATE INDEX way_seg_wsid_idx on way_seg (wsid); +CREATE INDEX way_seg_node_idx on way_seg (node); -- 2.39.5