Revision 5760
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 4631 | 4631 |
|
| 4632 | 4632 |
|
| 4633 | 4633 |
-- |
| 4634 |
-- Name: location_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4635 |
-- |
|
| 4636 |
|
|
| 4637 |
CREATE INDEX location_parent ON location USING btree (parent_id); |
|
| 4638 |
|
|
| 4639 |
|
|
| 4640 |
-- |
|
| 4634 | 4641 |
-- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4635 | 4642 |
-- |
| 4636 | 4643 |
|
Also available in: Unified diff
schemas/vegbien.sql: location: Added index on parent_id to speed up plot change over time joins