Revision 3233
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/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 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4603 | 4603 |
|
| 4604 | 4604 |
|
| 4605 | 4605 |
-- |
| 4606 |
-- Name: fki_specimenreplicate_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4607 |
-- |
|
| 4608 |
|
|
| 4609 |
CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate USING btree (datasource_id); |
|
| 4610 |
|
|
| 4611 |
|
|
| 4612 |
-- |
|
| 4613 | 4606 |
-- Name: fki_specimenreplicate_specimen_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4614 | 4607 |
-- |
| 4615 | 4608 |
|
| ... | ... | |
| 5226 | 5219 |
|
| 5227 | 5220 |
|
| 5228 | 5221 |
-- |
| 5229 |
-- Name: specimenreplicate_catalognumber_dwc; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5230 |
-- |
|
| 5231 |
|
|
| 5232 |
CREATE INDEX specimenreplicate_catalognumber_dwc ON specimenreplicate USING btree ((COALESCE(catalognumber_dwc, '\\N'::text))); |
|
| 5233 |
|
|
| 5234 |
|
|
| 5235 |
-- |
|
| 5236 |
-- Name: specimenreplicate_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5237 |
-- |
|
| 5238 |
|
|
| 5239 |
CREATE INDEX specimenreplicate_sourceaccessioncode ON specimenreplicate USING btree ((COALESCE(sourceaccessioncode, '\\N'::text))); |
|
| 5240 |
|
|
| 5241 |
|
|
| 5242 |
-- |
|
| 5243 | 5222 |
-- Name: specimenreplicate_unique_accessioncode_lookup; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5244 | 5223 |
-- |
| 5245 | 5224 |
|
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.