Revision 3070
Added by Aaron Marcuse-Kubitza over 12 years ago
| 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