Revision 4791
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 3707 | 3707 |
|
| 3708 | 3708 |
|
| 3709 | 3709 |
-- |
| 3710 |
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3711 |
-- |
|
| 3712 |
|
|
| 3713 |
CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence (taxonoccurrence_id); |
|
| 3714 |
|
|
| 3715 |
|
|
| 3716 |
-- |
|
| 3710 | 3717 |
-- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3711 | 3718 |
-- |
| 3712 | 3719 |
|
| ... | ... | |
| 3805 | 3812 |
|
| 3806 | 3813 |
|
| 3807 | 3814 |
-- |
| 3815 |
-- Name: locationevent_location; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3816 |
-- |
|
| 3817 |
|
|
| 3818 |
CREATE INDEX locationevent_location ON locationevent (location_id); |
|
| 3819 |
|
|
| 3820 |
|
|
| 3821 |
-- |
|
| 3808 | 3822 |
-- Name: locationevent_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3809 | 3823 |
-- |
| 3810 | 3824 |
|
| ... | ... | |
| 4057 | 4071 |
|
| 4058 | 4072 |
|
| 4059 | 4073 |
-- |
| 4074 |
-- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4075 |
-- |
|
| 4076 |
|
|
| 4077 |
CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence (locationevent_id); |
|
| 4078 |
|
|
| 4079 |
|
|
| 4080 |
-- |
|
| 4060 | 4081 |
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4061 | 4082 |
-- |
| 4062 | 4083 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added indexes for the analytical_db_view joins, as described at <https://projects.nceas.ucsb.edu/nceas/issues/494>