Revision 3252
Added by Aaron Marcuse-Kubitza over 12 years ago
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 |
|
Also available in: Unified diff
schemas/vegbien.sql: plantname: Removed unneeded indexes on plantname and rank (plantname_unique takes care of joins)