Revision 3070
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4149 | 4149 |
|
| 4150 | 4150 |
|
| 4151 | 4151 |
-- |
| 4152 |
-- Name: location_coords; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4153 |
-- |
|
| 4154 |
|
|
| 4155 |
|
|
| 4156 |
|
|
| 4157 |
|
|
| 4158 |
-- |
|
| 4152 | 4159 |
-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4153 | 4160 |
-- |
| 4154 | 4161 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4676 | 4676 |
|
| 4677 | 4677 |
|
| 4678 | 4678 |
-- |
| 4679 |
-- Name: location_coords; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4680 |
-- |
|
| 4681 |
|
|
| 4682 |
CREATE INDEX location_coords ON location USING btree ((COALESCE(centerlatitude, 'NaN'::double precision)), (COALESCE(centerlongitude, 'NaN'::double precision))); |
|
| 4683 |
|
|
| 4684 |
|
|
| 4685 |
-- |
|
| 4679 | 4686 |
-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4680 | 4687 |
-- |
| 4681 | 4688 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added location.location_coords index to speed up large imports by providing an index for merge joins