Revision 12614
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 9023 | 9023 |
|
| 9024 | 9024 |
|
| 9025 | 9025 |
-- |
| 9026 |
-- Name: plot_source_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 9027 |
-- |
|
| 9028 |
|
|
| 9029 |
|
|
| 9030 |
|
|
| 9031 |
|
|
| 9032 |
-- |
|
| 9026 | 9033 |
-- Name: project_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 9027 | 9034 |
-- |
| 9028 | 9035 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 11942 | 11942 |
|
| 11943 | 11943 |
|
| 11944 | 11944 |
-- |
| 11945 |
-- Name: plot_source_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 11946 |
-- |
|
| 11947 |
|
|
| 11948 |
CREATE INDEX plot_source_id ON location USING btree (source_id) WHERE (parent_id IS NULL); |
|
| 11949 |
|
|
| 11950 |
|
|
| 11951 |
-- |
|
| 11945 | 11952 |
-- Name: project_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 11946 | 11953 |
-- |
| 11947 | 11954 |
|
Also available in: Unified diff
fix: schemas/vegbien.sql: location: added plot_source_id index to provide the equivalent of the location.source_id index for outer plots. this will help Postgres choose the right query plans in queries involving outer plots.