source: subversion/sites/www.openstreetbrowser.org/src/sql/01_indices.sql @ 29773

Last change on this file since 29773 was 19793, checked in by skunk, 11 years ago

More indexes

  • create indexes on smoothness and impassable
File size: 3.7 KB
Line 
1create index node_tags_k on node_tags(k);
2create index way_tags_k on way_tags(k);
3create index relation_tags_k on relation_tags(k);
4
5create index relations_members_pk on relation_members (relation_id);
6create index relations_members_mem on relation_members (member_id);
7create index relations_members_type on relation_members (member_type);
8create index relations_members_role on relation_members (member_role);
9
10create index planet_osm_line_zorder on planet_osm_line(z_order);
11create index planet_osm_polygon_zorder on planet_osm_polygon(z_order);
12
13create index planet_osm_polygon_waterway on planet_osm_polygon("waterway");
14create index planet_osm_polygon_natural on planet_osm_polygon("natural");
15create index planet_osm_polygon_landuse on planet_osm_polygon("landuse");
16create index planet_osm_polygon_highway on planet_osm_polygon("highway");
17
18create index planet_osm_line_waterway on planet_osm_line("waterway");
19create index planet_osm_line_railway on planet_osm_line("railway");
20create index planet_osm_line_highway on planet_osm_line("highway");
21create index planet_osm_line_barrier on planet_osm_line("barrier");
22create index planet_osm_line_natural on planet_osm_line("natural");
23create index planet_osm_line_power on planet_osm_line("power");
24create index planet_osm_line_man_made on planet_osm_line("man_made");
25create index planet_osm_line_boundary on planet_osm_line(boundary);
26create index planet_osm_line_smoothness on planet_osm_line("smoothness");
27create index planet_osm_line_impassable on planet_osm_line("impassable");
28
29create index planet_osm_point_waterway on planet_osm_point("waterway");
30create index planet_osm_point_railway on planet_osm_point("railway");
31create index planet_osm_point_highway on planet_osm_point("highway");
32create index planet_osm_point_barrier on planet_osm_point("barrier");
33create index planet_osm_point_power on planet_osm_point("power");
34create index planet_osm_point_man_made on planet_osm_point("man_made");
35create index planet_osm_point_sport on planet_osm_point("sport");
36create index planet_osm_point_leisure on planet_osm_point("leisure");
37
38create index way_nodes_seq_id on way_nodes("sequence_id");
39
40create index planet_osm_line_addr_street on planet_osm_line("addr:street");
41create index planet_osm_point_addr_street on planet_osm_point("addr:street");
42create index planet_osm_point_addr_num on planet_osm_point("addr:housenumber");
43create index planet_osm_polygon_addr_street on planet_osm_polygon("addr:street");
44create index planet_osm_polygon_addr_num on planet_osm_polygon("addr:housenumber");
45
46create index planet_osm_point_amenity  on planet_osm_point(amenity);
47create index planet_osm_point_shop     on planet_osm_point(shop);
48create index planet_osm_point_tourism  on planet_osm_point(tourism);
49create index planet_osm_point_historic on planet_osm_point(historic);
50create index planet_osm_point_landuse  on planet_osm_point(landuse);
51create index planet_osm_point_cemetery on planet_osm_point(cemetery);
52
53create index planet_osm_polygon_amenity  on planet_osm_polygon("amenity");
54create index planet_osm_polygon_shop     on planet_osm_polygon("shop");
55create index planet_osm_polygon_tourism  on planet_osm_polygon("tourism");
56create index planet_osm_polygon_historic on planet_osm_polygon("historic");
57create index planet_osm_polygon_landuse  on planet_osm_polygon("landuse");
58create index planet_osm_polygon_cemetery on planet_osm_polygon("cemetery");
59create index planet_osm_polygon_power    on planet_osm_polygon("power");
60create index planet_osm_polygon_man_made on planet_osm_polygon("man_made");
61create index planet_osm_polygon_name     on planet_osm_polygon("name");
62create index planet_osm_polygon_sport    on planet_osm_polygon("sport");
63create index planet_osm_polygon_leisure  on planet_osm_polygon("leisure");
Note: See TracBrowser for help on using the repository browser.