Revision 5758
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4100 | 4100 |
|
| 4101 | 4101 |
|
| 4102 | 4102 |
-- |
| 4103 |
-- Name: stemobservation_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4104 |
-- |
|
| 4105 |
|
|
| 4106 |
CREATE INDEX stemobservation_plantobservation_id ON stemobservation (plantobservation_id); |
|
| 4107 |
|
|
| 4108 |
|
|
| 4109 |
-- |
|
| 4103 | 4110 |
-- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4104 | 4111 |
-- |
| 4105 | 4112 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4883 | 4883 |
|
| 4884 | 4884 |
|
| 4885 | 4885 |
-- |
| 4886 |
-- Name: stemobservation_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4887 |
-- |
|
| 4888 |
|
|
| 4889 |
CREATE INDEX stemobservation_plantobservation_id ON stemobservation USING btree (plantobservation_id); |
|
| 4890 |
|
|
| 4891 |
|
|
| 4892 |
-- |
|
| 4886 | 4893 |
-- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4887 | 4894 |
-- |
| 4888 | 4895 |
|
Also available in: Unified diff
schemas/vegbien.sql: stemobservation: Added index on plantobservation_id to speed up analytical_db_view joins