Revision 10792
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 6011 | 6011 |
|
| 6012 | 6012 |
|
| 6013 | 6013 |
-- |
| 6014 |
-- Name: taxonverbatim_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6015 |
-- |
|
| 6016 |
|
|
| 6017 |
CREATE INDEX taxonverbatim_source_id_idx ON taxonverbatim (source_id); |
|
| 6018 |
|
|
| 6019 |
|
|
| 6020 |
-- |
|
| 6021 |
-- Name: taxonverbatim_taxonlabel_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6022 |
-- |
|
| 6023 |
|
|
| 6024 |
CREATE INDEX taxonverbatim_taxonlabel_id_idx ON taxonverbatim (taxonlabel_id); |
|
| 6025 |
|
|
| 6026 |
|
|
| 6027 |
-- |
|
| 6014 | 6028 |
-- Name: taxonverbatim_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6015 | 6029 |
-- |
| 6016 | 6030 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 7238 | 7238 |
|
| 7239 | 7239 |
|
| 7240 | 7240 |
-- |
| 7241 |
-- Name: taxonverbatim_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7242 |
-- |
|
| 7243 |
|
|
| 7244 |
CREATE INDEX taxonverbatim_source_id_idx ON taxonverbatim USING btree (source_id); |
|
| 7245 |
|
|
| 7246 |
|
|
| 7247 |
-- |
|
| 7248 |
-- Name: taxonverbatim_taxonlabel_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7249 |
-- |
|
| 7250 |
|
|
| 7251 |
CREATE INDEX taxonverbatim_taxonlabel_id_idx ON taxonverbatim USING btree (taxonlabel_id); |
|
| 7252 |
|
|
| 7253 |
|
|
| 7254 |
-- |
|
| 7241 | 7255 |
-- Name: taxonverbatim_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7242 | 7256 |
-- |
| 7243 | 7257 |
|
Also available in: Unified diff
schemas/vegbien.sql: added covering indexes on foreign keys where needed. this enables rows to be cascadingly deleted without a full table scan.