Revision 3252
Added by Aaron Marcuse-Kubitza over 12 years ago
| 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)