Revision 5760
Added by Aaron Marcuse-Kubitza over 12 years ago
| 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 |
|
Also available in: Unified diff
schemas/vegbien.sql: location: Added index on parent_id to speed up plot change over time joins