Changes between Version 3 and Version 4 of CookBook join Corine Land Cover-RHT

Timestamp:

Sep 30, 2011 11:50:05 AM (14 years ago)

Author:

celine

Comment:

--

CookBook join Corine Land Cover-RHT

@@ -13 +13 @@
 
 {{{
+#!sql
 create schema clc2000;
 drop table if exists clc2000.area_clc;
@@ -152 +153 @@
 select * from rht.attributs_rht_fev_2011_vs2 where id_drain='223887'
 }}} 
+
+{{{
+#!sql
+CREATE INDEX indexareaclc
+ON clc2000.area_clc
+USING btree (reach_number);
+
+CREATE INDEX indexupareaclc
+ON clc2000.uparea_clc
+USING btree (reach_number);
+}}}