Revision 4791
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.sql | ||
|---|---|---|
| 4295 | 4295 |
|
| 4296 | 4296 |
|
| 4297 | 4297 |
-- |
| 4298 |
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4299 |
-- |
|
| 4300 |
|
|
| 4301 |
CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence USING btree (taxonoccurrence_id); |
|
| 4302 |
|
|
| 4303 |
|
|
| 4304 |
-- |
|
| 4298 | 4305 |
-- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4299 | 4306 |
-- |
| 4300 | 4307 |
|
| ... | ... | |
| 4393 | 4400 |
|
| 4394 | 4401 |
|
| 4395 | 4402 |
-- |
| 4403 |
-- Name: locationevent_location; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4404 |
-- |
|
| 4405 |
|
|
| 4406 |
CREATE INDEX locationevent_location ON locationevent USING btree (location_id); |
|
| 4407 |
|
|
| 4408 |
|
|
| 4409 |
-- |
|
| 4396 | 4410 |
-- Name: locationevent_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4397 | 4411 |
-- |
| 4398 | 4412 |
|
| ... | ... | |
| 4645 | 4659 |
|
| 4646 | 4660 |
|
| 4647 | 4661 |
-- |
| 4662 |
-- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4663 |
-- |
|
| 4664 |
|
|
| 4665 |
CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence USING btree (locationevent_id); |
|
| 4666 |
|
|
| 4667 |
|
|
| 4668 |
-- |
|
| 4648 | 4669 |
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4649 | 4670 |
-- |
| 4650 | 4671 |
|
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>