Revision 3234
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4162 | 4162 |
|
| 4163 | 4163 |
|
| 4164 | 4164 |
-- |
| 4165 |
-- Name: locationevent_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4166 |
-- |
|
| 4167 |
|
|
| 4168 |
|
|
| 4169 |
|
|
| 4170 |
|
|
| 4171 |
-- |
|
| 4172 |
-- Name: locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4173 |
-- |
|
| 4174 |
|
|
| 4175 |
|
|
| 4176 |
|
|
| 4177 |
|
|
| 4178 |
-- |
|
| 4179 | 4165 |
-- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4180 | 4166 |
-- |
| 4181 | 4167 |
|
| ... | ... | |
| 4183 | 4169 |
|
| 4184 | 4170 |
|
| 4185 | 4171 |
-- |
| 4186 |
-- Name: locationevent_obsstartdate; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4172 |
-- Name: locationevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4187 | 4173 |
-- |
| 4188 | 4174 |
|
| 4175 |
CREATE INDEX locationevent_previousobs_id_x ON locationevent (previous_id); |
|
| 4189 | 4176 |
|
| 4190 | 4177 |
|
| 4191 |
|
|
| 4192 | 4178 |
-- |
| 4193 |
-- Name: locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4179 |
-- Name: locationevent_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4194 | 4180 |
-- |
| 4195 | 4181 |
|
| 4182 |
CREATE INDEX locationevent_project_id ON locationevent (project_id); |
|
| 4196 | 4183 |
|
| 4197 | 4184 |
|
| 4198 |
|
|
| 4199 | 4185 |
-- |
| 4200 |
-- Name: locationevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4186 |
-- Name: locationevent_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4201 | 4187 |
-- |
| 4202 | 4188 |
|
| 4203 |
CREATE INDEX locationevent_previousobs_id_x ON locationevent (previous_id);
|
|
| 4189 |
CREATE INDEX locationevent_soiltaxon_id_x ON locationevent (soiltaxon_id);
|
|
| 4204 | 4190 |
|
| 4205 | 4191 |
|
| 4206 | 4192 |
-- |
| 4207 |
-- Name: locationevent_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4193 |
-- Name: locationevent_unique_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4208 | 4194 |
-- |
| 4209 | 4195 |
|
| 4210 | 4196 |
|
| 4211 | 4197 |
|
| 4212 | 4198 |
|
| 4213 | 4199 |
-- |
| 4214 |
-- Name: locationevent_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4200 |
-- Name: locationevent_unique_parent_authorcode_lookup; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4215 | 4201 |
-- |
| 4216 | 4202 |
|
| 4217 |
CREATE INDEX locationevent_soiltaxon_id_x ON locationevent (soiltaxon_id); |
|
| 4218 | 4203 |
|
| 4219 | 4204 |
|
| 4205 |
|
|
| 4220 | 4206 |
-- |
| 4221 |
-- Name: locationevent_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4207 |
-- Name: locationevent_unique_parent_location_lookup; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4222 | 4208 |
-- |
| 4223 | 4209 |
|
| 4224 | 4210 |
|
| 4225 | 4211 |
|
| 4226 | 4212 |
|
| 4227 | 4213 |
-- |
| 4228 |
-- Name: locationevent_unique_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4214 |
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4229 | 4215 |
-- |
| 4230 | 4216 |
|
| 4231 | 4217 |
|
| 4232 | 4218 |
|
| 4233 | 4219 |
|
| 4234 | 4220 |
-- |
| 4235 |
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4221 |
-- Name: locationevent_unique_project_authorcode_lookup; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4236 | 4222 |
-- |
| 4237 | 4223 |
|
| 4238 | 4224 |
|
Also available in: Unified diff
schemas/vegbien.sql: locationevent: Added covering lookup indexes on the unique constraints to enable fast merge joins in column-based import. Removed no longer needed individual-column lookup indexes because the constraint-covering lookup indexes now handle lookups. This also avoids index bloat.