Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle.sql @ 3339:790c12c55abb
Backend: Added DB indices for fasten access to cross section points.
flys-backend/trunk@4927 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 11 Jul 2012 10:37:03 +0000 |
| parents | e19a503e4150 |
| children | 3442304b430a |
comparison
equal
deleted
inserted
replaced
| 3338:e19a503e4150 | 3339:790c12c55abb |
|---|---|
| 65 river_id NUMBER(38,0), | 65 river_id NUMBER(38,0), |
| 66 time_interval_id NUMBER(38,0), | 66 time_interval_id NUMBER(38,0), |
| 67 PRIMARY KEY (id) | 67 PRIMARY KEY (id) |
| 68 ); | 68 ); |
| 69 | 69 |
| 70 -- Indices for faster access of the points | |
| 71 CREATE INDEX cross_section_lines_km_idx | |
| 72 ON cross_section_lines(km); | |
| 73 CREATE INDEX cross_section_points_line_idx | |
| 74 ON cross_section_points(cross_section_line_id); | |
| 70 | 75 |
| 71 -- DISCHARGE_TABLE_VALUES | 76 -- DISCHARGE_TABLE_VALUES |
| 72 CREATE SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ; | 77 CREATE SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ; |
| 73 | 78 |
| 74 CREATE TABLE discharge_table_values ( | 79 CREATE TABLE discharge_table_values ( |