Revision 5760
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3848 | 3848 |
|
| 3849 | 3849 |
|
| 3850 | 3850 |
-- |
| 3851 |
-- Name: location_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3852 |
-- |
|
| 3853 |
|
|
| 3854 |
CREATE INDEX location_parent ON location (parent_id); |
|
| 3855 |
|
|
| 3856 |
|
|
| 3857 |
-- |
|
| 3851 | 3858 |
-- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3852 | 3859 |
-- |
| 3853 | 3860 |
|
| schemas/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