Revision 1250
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4371 | 4371 |
|
| 4372 | 4372 |
|
| 4373 | 4373 |
-- |
| 4374 |
-- Name: plantname_rank; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4375 |
-- |
|
| 4376 |
|
|
| 4377 |
CREATE INDEX plantname_rank ON plantname (rank); |
|
| 4378 |
|
|
| 4379 |
|
|
| 4380 |
-- |
|
| 4374 | 4381 |
-- Name: plantname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4375 | 4382 |
-- |
| 4376 | 4383 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4768 | 4768 |
|
| 4769 | 4769 |
|
| 4770 | 4770 |
-- |
| 4771 |
-- Name: plantname_rank; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4772 |
-- |
|
| 4773 |
|
|
| 4774 |
CREATE INDEX plantname_rank ON plantname USING btree (rank); |
|
| 4775 |
|
|
| 4776 |
|
|
| 4777 |
-- |
|
| 4771 | 4778 |
-- Name: plantname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4772 | 4779 |
-- |
| 4773 | 4780 |
|
Also available in: Unified diff
vegbien.sql: plantname: Added index on rank to speed up specimens verifications, where the query planner insists on joining from plantname to specimenreplicate instead of the other way around (which takes much longer without the index)