1 CREATE UNIQUE INDEX poi_lat_lon_idx on poi (lat, lon, cat_id);
2 CREATE INDEX poi_priority on poi (priority);
4 CREATE INDEX node_lat_idx on nodes (lat);
5 CREATE INDEX node_lon_idx on nodes (lon);
7 CREATE INDEX way_name_idx on way_names (name);
8 CREATE INDEX way_ref_idx on way_ref (ref);
10 CREATE INDEX way_seg2_wsid_idx on way_s2s (wsid);
11 CREATE INDEX way_seg_f_idx on way_s2s (f);
12 CREATE INDEX way_seg_t_idx on way_s2s (t);