Revision 3252
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4463 | 4463 |
|
| 4464 | 4464 |
|
| 4465 | 4465 |
-- |
| 4466 |
-- Name: plantname_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4467 |
-- |
|
| 4468 |
|
|
| 4469 |
CREATE INDEX plantname_plantname_x ON plantname (plantname); |
|
| 4470 |
|
|
| 4471 |
|
|
| 4472 |
-- |
|
| 4473 |
-- Name: plantname_rank; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4474 |
-- |
|
| 4475 |
|
|
| 4476 |
CREATE INDEX plantname_rank ON plantname (rank); |
|
| 4477 |
|
|
| 4478 |
|
|
| 4479 |
-- |
|
| 4480 | 4466 |
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4481 | 4467 |
-- |
| 4482 | 4468 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4995 | 4995 |
|
| 4996 | 4996 |
|
| 4997 | 4997 |
-- |
| 4998 |
-- Name: plantname_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4999 |
-- |
|
| 5000 |
|
|
| 5001 |
CREATE INDEX plantname_plantname_x ON plantname USING btree (plantname); |
|
| 5002 |
|
|
| 5003 |
|
|
| 5004 |
-- |
|
| 5005 |
-- Name: plantname_rank; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5006 |
-- |
|
| 5007 |
|
|
| 5008 |
CREATE INDEX plantname_rank ON plantname USING btree (rank); |
|
| 5009 |
|
|
| 5010 |
|
|
| 5011 |
-- |
|
| 5012 | 4998 |
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5013 | 4999 |
-- |
| 5014 | 5000 |
|
Also available in: Unified diff
schemas/vegbien.sql: plantname: Removed unneeded indexes on plantname and rank (plantname_unique takes care of joins)