Changes between Version 17 and Version 18 of CookBook join BDMAP_CCM v2

Timestamp:

Nov 8, 2010 4:43:13 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM v2

@@ -57 +57 @@
 
 {{{
-select * from hylcov_node full outer join noeud_troncon_final on ID_SOM=Id_BDCARTHAGE limit 100;
+CREATE INDEX hylcov_node_ID_SOM
+  ON hylcov_node
+  USING btree
+  (ID_SOM);
+  CREATE INDEX hylcov_arc_id_som_f
+  ON hylcov_arc
+  USING btree
+  (id_som_f);
+
+
+
+CREATE INDEX hylcov_arc_ID_SOM
+  ON hylcov_node
+  USING btree
+  (ID_SOM);
+create view hylcov_arc_dist a
+
+CREATE INDEX noeud_troncon_final_Id_BDCARTHAGE
+  ON noeud_troncon_final
+  USING btree
+  (Id_BDCARTHAGE);
+
+drop view if exists (hylcov_arc_dist)
+create view hylcov_arc_dist as(
+select * from hylcov_arc h left join  noeud_troncon_final n on id_som_f=Id_BDCARTHAGE );
 }}}