Revision 5759
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3841 | 3841 |
|
| 3842 | 3842 |
|
| 3843 | 3843 |
-- |
| 3844 |
-- Name: location_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3845 |
-- |
|
| 3846 |
|
|
| 3847 |
CREATE INDEX location_creator ON location (creator_id); |
|
| 3848 |
|
|
| 3849 |
|
|
| 3850 |
-- |
|
| 3844 | 3851 |
-- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3845 | 3852 |
-- |
| 3846 | 3853 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4624 | 4624 |
|
| 4625 | 4625 |
|
| 4626 | 4626 |
-- |
| 4627 |
-- Name: location_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4628 |
-- |
|
| 4629 |
|
|
| 4630 |
CREATE INDEX location_creator ON location USING btree (creator_id); |
|
| 4631 |
|
|
| 4632 |
|
|
| 4633 |
-- |
|
| 4627 | 4634 |
-- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4628 | 4635 |
-- |
| 4629 | 4636 |
|
Also available in: Unified diff
schemas/vegbien.sql: location: Added index on creator_id to speed up analytical_db_view joins