Revision 3233
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4071 | 4071 |
|
| 4072 | 4072 |
|
| 4073 | 4073 |
-- |
| 4074 |
-- Name: fki_specimenreplicate_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4075 |
-- |
|
| 4076 |
|
|
| 4077 |
CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate (datasource_id); |
|
| 4078 |
|
|
| 4079 |
|
|
| 4080 |
-- |
|
| 4081 | 4074 |
-- Name: fki_specimenreplicate_specimen_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4082 | 4075 |
-- |
| 4083 | 4076 |
|
| ... | ... | |
| 4694 | 4687 |
|
| 4695 | 4688 |
|
| 4696 | 4689 |
-- |
| 4697 |
-- Name: specimenreplicate_catalognumber_dwc; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4698 |
-- |
|
| 4699 |
|
|
| 4700 |
|
|
| 4701 |
|
|
| 4702 |
|
|
| 4703 |
-- |
|
| 4704 |
-- Name: specimenreplicate_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4705 |
-- |
|
| 4706 |
|
|
| 4707 |
|
|
| 4708 |
|
|
| 4709 |
|
|
| 4710 |
-- |
|
| 4711 | 4690 |
-- Name: specimenreplicate_unique_accessioncode_lookup; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4712 | 4691 |
-- |
| 4713 | 4692 |
|
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate: Removed no longer needed individual-column lookup indexes because the constraint-covering lookup indexes now handle lookups. This also avoids index bloat.